Thanks Robert...

By the way, I haven't forgotten the discussions we had some time ago
regarding hosting.  It's just tough to pry these clients off that damn CF
crap!  Hopefully with Witango we'll be talking again soon.

Tom

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Robert Shubert
Sent: Tuesday, August 27, 2002 7:03 PM
To: Multiple recipients of list witango-talk
Subject: Re: Witango-Talk: Key of Record Just Written


Tom,

Typically we:

Begin Transaction
Insert Record
Retrieve Highest Identity
Close Transaction

Robert Shubert
Tronics
Thomas Ferguson wrote:
>
> nevermind...  since it was an autonum, I just retreived the last row and
> extracted the key.
>
> Any idea on how to do this without an autonum and no date/time stamp?
>
> Just curious.
>
> TIA
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas Ferguson
> Sent: Tuesday, August 27, 2002 6:06 PM
> To: Multiple recipients of list witango-talk
> Subject: Witango-Talk: Key of Record Just Written
>
> I know I've seen this before, but I can't find it in the archives...
>
> How do I get the value of the key of the record I just wrote?  I'm using
MS
> SQL with the key defined as an AutoNum (Identity).
>
> Thanks in advance
>
> Top Ferguson
> ARiSAR, Inc.
>
> 727.577.7474 - Office
> 727.577.7494 - Fax
> 727.510-9863 - Mobile
>
> www.arisar.com
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
>                 with unsubscribe witango-talk in the message body
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
>                 with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

Reply via email to