Valentina RecID, LastInserted

[Ruslan Zasukhin]

On 3/14/06 4:14 PM, "Timo Rehmann" <valentina at pixelrund.de> wrote:

>> You can use for now
>> 
>>    Cursor.AddRecord()
>> 
>> If you use INSERT then no way for now get its new recID.
>> 
>> 
>>   
> hi ruslan, thanks so far, but it is not absolutely clear to me, yet:
> 
> so far i'm using sqlExecute("insert into ...") for inserting new data.

right

> you're approach means to use VCursor-functions to add a new record? will
> addRecord() modify the database directly or do i have to pass the cursor
> to an execute-function??

    curs = db.SqlSelect( "SELECT f1, f2, ,.. from T WHERE false" )

    curs.field("f1").value = xxx
    curs.field("f2").value = xxx

    newRecID = curs.AddRecord()
 
> one more problem/question:
> 
> after inserting data into a table i try to use sqlExecute() to add data
> to another table. following error occurs:
> 
> Kernel Error: 0x51500
> Identifier "content" is not found.
 
> sql1: insert into pages ...
> sql2: insert into content...
> 
> any ideas?

Content this is name of table ??

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