Stephen Bond
stephen at bondsoftware.co.nz
Tue May 6 19:12:33 CDT 2003
Andrew, just to complete the knowledge flowing freely here (great stuff), if I've used a SQL statement to INSERT the new record, can I use @@Identity (and how)? Thanks Stephen Bond -----Original Message----- From: Haslett, Andrew [mailto:andrew.haslett at ilc.gov.au] Sent: Wednesday, 7 May 2003 10:43 a.m. To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] New ID/Autonumber value Jet 4.0 supports @@Identity. Therefore if you are inserting your record in code using ADO then it will work fine. Cheers, Andrew -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Wednesday, 7 May 2003 2:01 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] New ID/Autonumber value I don't think that works in MDBs, which I assume Stephen meant, else he would have posted on the SQL list. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Haslett, Andrew Sent: May 6, 2003 12:09 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] New ID/Autonumber value SELECT @@IDENTITY -----Original Message----- From: Stephen Bond [mailto:stephen at bondsoftware.co.nz] Sent: Tuesday, 6 May 2003 12:23 PM To: accessd at databaseadvisors.com Subject: [AccessD] New ID/Autonumber value In this thread a couple of months ago there was a solution offered to the problem of determining the value of an ID Autonumber of a record just added. It was stunning in its simplicity, so of course I didn't write it down ;-( Can anyone help? TIA Stephen Bond Otatara, New Zealand ( tel 03 213 1256 fax 03 213 0123 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com