I worked with the demo four the last 5 days and today I order the professionnal version of SQL SDAC. Unfortunately, I cannot find any samples or demo that use the LocateEx method. My application is not a visual one and I want to read the records from a Memory Dataset without Grid or any other datasource. Because there is no more examples in the PDF documentation, could you tell me where I can find some sample codes that do record manipulation inside a TMemDataSet?
Thanks!
Samples that use LocateEx inside a TMemDataset
You can find an example of using Locate method in SdacDemo\VirtualTable.
To read a data from the dataset you can use a code like the following:
To read a data from the dataset you can use a code like the following:
Code: Select all
MSQuery.Open;
while not MSQuery.Eof do begin
i := MSQuery.FieldByName('F1').AsInteger;
s := MSQuery.FieldByName('F2').AsString;
MSQuery.Next;
end;
MSQuery.Close;