Integrating three tables

[Ruslan Zasukhin]

On 12/10/05 4:56 PM, "jda" <jda at his.com> wrote:

> Next issue:
> 
> I need the RecID to create the links. But when I import a new record
> via a cursor (addRecord), the recID is not updated. In other words
> 
>       myDatabase.LastInsertedRecID
> 
> returns NOT the new recID, but the one before it.
> 
> I could just use
> 
>       myDatabase.LastInsertedRecID
> 
> except this applies to the database, not the table I'm adding to. If
> the last inserted RecID is for another table, this value will be
> wrong. What I think I need is
> 
>       myDatabase.myTable.LastInsertedRecID

No. Yo do not need it.

myDatabase.LastInsertedRecID returns RecID of ANY just only inserted record.
    Never mind what table.
 
> but that isn't available.
> How to unambiguously get the id of the next record to be added?


In any case this should work best of all:

    NewRecID = curs1.AddRecord()  // add record into T1






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