Subject Equivalent SQL to Dataset.Locate statement
Author Nols Smit

In a FireBird 1.5 and Delphi 7 application, when the user transmit a key value of a table, I use the Pascal DataSet.Locate statement:
if not IBDRegister.Locate('Specimen_Nr', VarArrayOf([This_ID]), [loPartialKey]) then
ShowMessage('No such record!');

But it seems very slow in execution. What will the equivalent SQL Select statement be to locate a specific record but not to limit the user to that record located. In other words: After execution of the statement, the user must be able to move to previous and next record.


Nols Smit

Disclaimer Legal Notice:
By having opened and read this electronic mail, you are deemed to have
understood and accepted all disclaimers and conditions pertaining to
electronic mail emanating from, and received by The Council for Geoscience,
further detail of which may be viewed at the following hyperlink:

[Non-text portions of this message have been removed]