Valentina RecID, LastInserted

[Ruslan Zasukhin]

On 3/14/06 1:50 PM, "Timo Rehmann" <valentina at pixelrund.de> 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.


-- 
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]