Re: Generating the next sequential key...

From: David Lightstone <david._NoSpamlightstone_at_prodigy.net>
Date: Tue, 02 May 2006 11:07:04 GMT
Message-ID: <s3H5g.27078$NS6.820@newssvr30.news.prodigy.com>

<timasmith_at_hotmail.com> wrote in message news:1146507603.184356.85940_at_e56g2000cwe.googlegroups.com...
>
> I didnt think the autoincrementing column was any use in MSAccess
> because I need the value generated for child tables and you cant get
> the value until it is generated - and even then you have to do a lookup
> to get it (by some *other* unique index since you dont have the pkey
> yet...eeesh).
>
> Please correct me if MSAccess has progressed beyond that.

If perchance you are creating the records under program control (which I am) you can get the key when the record is created, but before it has been populated with values (other than the key)

>
> Not familiar with SQL Server. As I said above I dont mind coding for a
> few databases I can test - but I would like to ship a generic solution
> for all other databases - in which case a or b would probably work
> though neither is elegant.
>
Received on Tue May 02 2006 - 06:07:04 CDT