Page 1 of 1

Samples that use LocateEx inside a TMemDataset

Posted: Fri 22 Feb 2008 19:46
by toxedo
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!

Posted: Tue 26 Feb 2008 10:03
by Plash
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:

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;