Yeah I figured I would have to go back in. I have a timestamp being placed in. I can do a select using it and another value to get the record number after the insert.
I sure wished Access support @@IDENTITY or something like it. Troy > -----Original Message----- > From: MacGown, Peter [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 2:51 PM > To: 'Troy Sniff'; [EMAIL PROTECTED] > Subject: RE: Returning auto incremented value on insert > > > I work with MS Access quite a bit and you can't quite do what > you want in > Access either. What I do there is create a unique > combination of something > like the following: > > TIMESTAMP as datefield > USERNAME as text(50) > > SAVETIME = NOW() > > I write the record and then, do a select on the record where > TIMESTAMP = > SAVETIME AND USERNAME = CURRENT USER NAME > > I suppose you could even use a session number as well if you > could get it. > > I have been programming pretty intensely with MS Access for a > number of > years now and this is the only way I found to do what you > want. I'm not > quite sure how to do it in Perl since I am a newbie at it, > but I'm sure you > could use the same approach. > > I'm very interested in how you get Perl to work with MS > Access databases. I > can get it to work using the command line, but I can't get it > to work using > CGI. > > I hope that this was helpful. > > Thanks, > Pete MacGown > AT&T Broadband > > -----Original Message----- > From: Troy Sniff [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 4:09 PM > To: [EMAIL PROTECTED] > Subject: Returning auto incremented value on insert > > > I am performing an insert into an access table where the > primary key is > set to auto increment. > > When I insert a record, is there an easy way to grab the value created > by the auto increment without having to go back in read the newly > created record? > > I need the value to display a result such as: > > "Your information has been added. The record number assigned > was 1000. > We recommend you write this down for future reference". > > Troy > > >
