Valentina RecID, LastInserted

[Ruslan Zasukhin]

On 3/14/06 2:38 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> Hi Timo,
> 
>> hello folks,
>> 
>> is there any method to get the last inserted RecID of an table?
>> 
>> it will not work to use sql like this:
>> 
>> "select RecId from table order by RecID desc limit 1"
>> 
>> because deleted RecID-placeholder will be used during next insert...
> 
> You can use for now
> 
>    Cursor.AddRecord()
> 
> If you use INSERT then no way for now get its new recID.

I forget one more new way:

    Vdatabase.LastInsertedRecID

This property contains RecID of last inserted record,
    never mind into which table.
    This can help for INSERT


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]