> "Frank" == Frank Millman <[EMAIL PROTECTED]> writes:
Frank> SELECT @@IDENTITY returns the most recent of all
Frank> inserts. If you have a complex transaction which triggers
Frank> inserts into other tables, it may not return the one you
Frank> want.
Frank> This one allo
Steve Holden wrote:
> Albert Leibbrandt wrote:
> >
> > jeffhg582003 wrote:
> >
> >
> >>Hi,
> >>
> >>I am developing a python script which add records to
> >>a microsoft access tables. All my tables have autogenerated number
> >>fields. I am trying to capture the number generated from the insert bu
"jeffhg582003" <[EMAIL PROTECTED]> wrote:
>
>I am developing a python script which add records to
>a microsoft access tables. All my tables have autogenerated number
>fields. I am trying to capture the number generated from the insert but
>I am not exactly sure how to do that after an insert.
htt
"jeffhg582003" <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> fields. I am trying to capture the number generated from the insert
but
> I am not exactly sure how to do that after an insert.
Other folks have pointed you to "select @@identity" but I thought I
should mention that if you u
Albert Leibbrandt wrote:
>
> jeffhg582003 wrote:
>
>
>>Hi,
>>
>>I am developing a python script which add records to
>>a microsoft access tables. All my tables have autogenerated number
>>fields. I am trying to capture the number generated from the insert but
>>I am not exactly sure how to do t
I can't remember the detail right now but look at SELECT @@IDENTITY.
Cheers,
Davy M
--
http://mail.python.org/mailman/listinfo/python-list
jeffhg582003 wrote:
>Hi,
>
>I am developing a python script which add records to
>a microsoft access tables. All my tables have autogenerated number
>fields. I am trying to capture the number generated from the insert but
>I am not exactly sure how to do that after an insert.
>
>Thanks,
>Jeff
>
