#1 2014-09-09 05:07:45

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.

Offline

#2 2014-09-09 06:14:03

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
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.

Offline

#3 2014-09-09 13:21:04

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 ?

Offline

Board footer

Powered by FluxBB