<< Click to Display Table of Contents >> Navigation:  Sources > SQL Query

Example of performing query on another query from SQL databse.

 
Schema := TDMSchema.Create('', TDMFDProvider.Create('localhost:d:\mydb.fdb@sysdba;masterkey', Firebird));
try
  Schema.Provider.Q.Select('select first 100 * from customers');
  s := THtSQL.FromDataset(Schema.Provider.Q.Dataset, 'select * from data', []).AsJSON;
finally
  Schema.Free
end;