Hi,
I could also add that I use this with mssql:
SELECT IDENT_CURRENT('table name') as LastId
Gauthier
----- Original Message -----
From: "Dan" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 6:52 PM
Subject: Re: Witango-Talk: Finding out the new key in an insert action
inMS-SQL
> Hi Scott,
>
> Thanks for your explanation. Now I understand why I was confused: the @@
> wasn't the witango , but the SQL one. Meanwhile I've used an alternative
> solution which involves an extra datetime column in which I place the
> curentdatestamp and then I select on this date plus the userID which
> produces a single record. Not the most pretty of solutions, but it works
;-)
>
> Dan
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
