Getting New RecID after SQL INSERT, Frank?

[Frank Schima]

On Aug 20, 2004, at 12:05 PM, Ruslan Zasukhin wrote:

> On 8/20/04 6:59 PM, "halldorg at vortex.is" <halldorg at vortex.is> 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. In 
Valentina, it only needs to work with the RecID field.

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


-Frank