[V4Rb] VDatabase.LastInsertedRecID

[Charles Yeomans]

On Oct 15, 2005, at 6:23 PM, Ruslan Zasukhin wrote:

> 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

Okay, this makes sense.

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

But I thought Valentina liked doing what no other DBMS does :)


--------------
Charles Yeomans