How to select the current record only with SELECT statement
On Thu, 26 Apr 2001 09:37:40 -0700, "Asif Anwar"
Quote:
>How can I select only the current record with the SELECT Statement.
>Thanks
>Asif
Asif,
I am not sure what you mean by "Current Record".
If your tables all have a Primary Index field (which I recommend), and
the record is not in the process of creation then it is easy.
Get the Primary Index value for the record, and put it in a statement
like this:
"SELECT * FROM MyTable WHERE MyIndex = " & CStr( CurrentIndexNumber )
If you do not have a Primary Index field, then selecting a single
record can be difficult, if not impossible.
