[V4Rb] VDatabase.LastInsertedRecID

[Ruslan Zasukhin]

On 10/16/05 12:56 AM, "Charles Yeomans" <yeomans at desuetude.com> wrote:

>> You may use something like this:
>> SQLExecute( "insert into t1 ..." )
>> SQLExecute(    "    insert    into   t2   (ptr_to_t1_Field)   values(
>>  "   +
>> VDatabase.LastInsertedRecID + ")" )
> 
> I suppose, but I am curious about the question of design; a recID is a
> property of a record and a table, so it seems to me that VTable is the
> appropriate place for such a property.

Yes, right but:

1) mySQL have this on DB level.

    and we was need the same for VPHP to repeat mySQL API

2) we have consider storing of this in TABLE, but

    a) this make things much more complex internally.
    b) it seems any other DBMS do not do this.


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