mORMot Open Source

mariomoretti

Member

From: italy

Registered: 2012-01-29

Posts: 88

TSQLTableJson with no ID field

Hi,
i'm trying to create a tSQLTableJson to view rows in a tSQLTableToGrid.

     fTableJSON := fClient.ExecuteList([fTable], 'select * from eb_currencies');

fTable is the table EB_CURRENCIES of the model.
fClient is a tSQLHTTPClient.
The table is external and has 8 fields the first of them is ID , added by the framework.

FTableJSON return only 7 fields , all except ID.

I've debugged the server side and , after call to sqlite3.prepare_v2 with 'select * from eb_currencies', the line

  fFieldCount := sqlite3.column_count(fRequest);

returns 7 in ffieldcount and, obviuosly, the table returns all fields except ID.

May someone help me ?
Thanks.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: TSQLTableJson with no ID field

Never seen that.
Something may be wrong with your table definition.

Without simple code to reproduce the problem, we can't help.

mariomoretti

Member

From: italy

Registered: 2012-01-29

Posts: 88

Re: TSQLTableJson with no ID field

te gà rasùn : in milanese means that you are right.
I've recreated the tables to send you not all the project, and now works well.
But table definition in old db is the same  : may be i have changed something in property definition of other tables of the model ?