SQL way of getting last recID

[Charles Yeomans]

On Mar 19, 2004, at 4:31 PM, Ruslan Zasukhin wrote:

> On 3/19/04 1:29 AM, "James Kleinschmidt" <jkleins at shentel.net> wrote:
>
>> Is there a way to get the recID of the last added record for a table 
>> if
>> it was added with the insert sql command?
>
> Hi James,
>
> It seems know.
>
> We need invent something.
>
> You have ideas What syntax we can use for this?
>

How about
db.SQLExecute("GET NEWEST recID For TableName") as Integer?

Charles Yeomans