FillWithDASql problem

Data Abstract
1

Hi,
I have an error as following. It should be something wrong in TDAMemDataTable if “RemoteFetchEnable = False” and “LogicalName = Table”.

I use “FillWithDASql” function that fill the data into TDAMemDataTable. First time has “CartonType” field in DASQL. Second time hasn’t “CartonType” field. Then it will have following error.

image

image

Need it to have same fields when I use FillWithDASql?

Thanks.

2

Hi,

try to clear table’s fields before second call like

      lRemoteDataAdapter.FillWithDASql(lTable,DASQL1,nil);
...
      lTable.Fields.Clear;
      lRemoteDataAdapter.FillWithDASql(lTable,DASQL2,nil);

You have asked to store table’s fields at Calculate field doesn’t work for FillWithDASql requests
as a result, 2nd call uses table’s fields from 1st call.

3

Noted with thanks. Problem solved.