Getting New RecID after SQL INSERT

Ivan Smahin IvanSmahin at public.kherson.ua
Fri Aug 20 16:55:17 CDT 2004


Hello Ruslan,

Friday, August 20, 2004, 12:17:27 AM, you wrote:

RZ> On 8/19/04 11:32 PM, "Frank Schima"
RZ> <frank-list2 at mindstarprods.com> wrote:

>> Hi all,
>> 
>> 
>> I can't seem to recall if there is a way to get the RecID of a newly
>> INSERTed record using SQL? I'm using V4RB 1.10. I know how to do it
>> with Table methods but I want to use a pure SQL method if possible.
>> 
>> I'm sure we'll have this in Valentina 2.


RZ> Hi Frank,

RZ> Actually I think we have no yet this feature.

RZ> And if I not mistake, ALL dbms I have see, resolve this
RZ> Via API function  get_last_id()

RZ> Am I right ?



Exactly.

-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua



More information about the Valentina mailing list