DA SQL, where to add?

Data Abstract
, ,
1

I like to run SQL queries at client side, is it possible with DA? Can’t find any SQL component, only TDAMemtable.

With DA SQL you can execute queries against DB but i don’t get where SQL statements should be added? I guess it’s should be used in Schema Modeler but where in there?

2

Hi,

you can use any of these methods:

DARemoteDataAdapter.FillWithDASql(memtable, sql, Parameters);
DARemoteDataAdapter.FillWithDASql([memtable], [sql], [Parameters]);
DARemoteDataAdapter.FillWithDASql([memtable], [sql]);

pls review the DASQL sample for more details.