Getting New RecID after SQL INSERT, Frank?

[Ruslan Zasukhin]

On 8/20/04 9:46 PM, "Frank Schima" <frank-list2 at mindstarprods.com> wrote:

>>>> FS> Usually they have a SQL way to do that. For instance in MySQL it
>>>> is:
>>>> 
>>>> FS>     SELECT LAST_INSERT_ID()
>> 
>> Frank,
>> 
>> Please remind me,
>> 
>> Since mySQL is RDBMS,
>> 
>> And PK can be any type, then this function can return integer, double
>> or
>> string value, yes?
> 
> It can only be used with auto-increment fields which are integers.

Hmm. You sure ?

I do not see technical problems for mySQL to return different types.


> In Valentina, it only needs to work with the RecID field.

Frank, but Valentina also should be able act as RDBMS.


> Sybase is similar in that it works with its "Identity" field which is
> essentially an auto-incrementing integer.

Okay,

I think in 1-2 weeks we will work on this task for 2.0

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------