>>>>How would I determine the last record in a DBF using SQL?
>>>>I've seem some examples on the net but they are = sql engine specific.
>>>
>>>What is the defenition of the last record? Which column(s) determine the order?
>>
>>The last record entered into the table chronologically.
>
>You have to have a column in the table that holds this information. There's no such thing as chronological order in the tables on client-sever backends in general. For MS SQL server, for example, the records are ordered either by clustered index, if there's one, or not ordered at all.
Sergey,
I think you have overlooked that Timothy specifies that he means DBFs.