> > Following Odbc-Access manuals, you should use:
> > select @@identity
> > with no table name. this value is the last value of the last modified
> > recordset on that database.
> what's the name of the value it returns?
Whatever you want it to be - you should alias it;
select @@identity as newID
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
> -----Original Message-----
> From: jamesa {James Alexander} [mailto:[EMAIL PROTECTED]]
> Sent: 03 August 2000 20:17
> To: '[EMAIL PROTECTED]'
> Subject: RE: Access AutoiNumber Fields
>
>
>
> -----Original Message-----
> From: Miguel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 03, 2000 11:09 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Access AutoiNumber Fields
>
>
>
> Mike
> www.ibcmass.com
> mailto:[EMAIL PROTECTED]
>
>
> > -----Mensaje original-----
> > De: Jonathan R. Karlen [mailto:[EMAIL PROTECTED]]
> > Enviado el: jueves 3 de agosto de 2000 16:14
> > Para: [EMAIL PROTECTED]
> > Asunto: Access AutoiNumber Fields
> >
> >
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_0004_01BFFD33.9974EEC0
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: 7bit
> >
> > How do you get the value used by Access in an AutoNumber field. For
> > example, you insert a record into one table and then, within the same
> > template, need to use the ID assigned to that record.
> >
> >
> >
> > ***************************************
> > Jonathan R. Karlen
> > Karlen Internet Solutions
> > Web Site and Application Development
> > [EMAIL PROTECTED]
> > http://www.karlen.com
> >
> >
> > ------=_NextPart_000_0004_01BFFD33.9974EEC0
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
> > xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> > xmlns=3D"http://www.w3.org/TR/REC-html40">
> >
> > <head>
> > <meta http-equiv=3DContent-Type content=3D"text/html; =
> > charset=3Diso-8859-1">
> > <meta name=3DProgId content=3DWord.Document>
> > <meta name=3DGenerator content=3D"Microsoft Word 9">
> > <meta name=3DOriginator content=3D"Microsoft Word 9">
> > <link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]">
> > <!--[if gte mso 9]><xml>
> > <o:OfficeDocumentSettings>
> > <o:DoNotRelyOnCSS/>
> > </o:OfficeDocumentSettings>
> > </xml><![endif]--><!--[if gte mso 9]><xml>
> > <w:WordDocument>
> > <w:View>Normal</w:View>
> > <w:Zoom>0</w:Zoom>
> > <w:DocumentKind>DocumentEmail</w:DocumentKind>
> > <w:EnvelopeVis/>
> > </w:WordDocument>
> > </xml><![endif]-->
> > <style>
> > <!--
> > /* Style Definitions */
> > p.MsoNormal, li.MsoNormal, div.MsoNormal
> > {mso-style-parent:"";
> > margin:0in;
> > margin-bottom:.0001pt;
> > mso-pagination:widow-orphan;
> > font-size:12.0pt;
> > font-family:Arial;
> > mso-fareast-font-family:"Times New Roman";
> > mso-bidi-font-family:"Times New Roman";}
> > p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
> > {margin:0in;
> > margin-bottom:.0001pt;
> > mso-pagination:widow-orphan;
> > font-size:12.0pt;
> > font-family:Arial;
> > mso-fareast-font-family:"Times New Roman";
> > mso-bidi-font-family:"Times New Roman";}
> > span.EmailStyle15
> > {mso-style-type:personal-compose;
> > mso-ansi-font-size:10.0pt;
> > mso-ascii-font-family:Arial;
> > mso-hansi-font-family:Arial;
> > mso-bidi-font-family:Arial;
> > color:black;}
> > @page Section1
> > {size:8.5in 11.0in;
> > margin:1.0in 1.25in 1.0in 1.25in;
> > mso-header-margin:.5in;
> > mso-footer-margin:.5in;
> > mso-paper-source:0;}
> > div.Section1
> > {page:Section1;}
> > -->
> > </style>
> > </head>
> >
> > <body lang=3DEN-US style=3D'tab-interval:.5in'>
> >
> > <div class=3DSection1>
> >
> > <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> > color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>How do you
> > get the value used by Access in an AutoNumber field.<span =
> > style=3D"mso-spacerun:
> > yes"> </span>For example, you insert a record into one
> > table and =
> > then,
> > within the same template, need to use the ID assigned to that =
> > record.<o:p></o:p></span></font></span></p>
> >
> > <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> > color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
> > !supportEmptyParas]> <![endif]><o:p></o:p></span></font><
> > /span></p>
> >
> > <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> > color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
> > !supportEmptyParas]> <![endif]><o:p></o:p></span></font><
> > /span></p>
> >
> > <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> > color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
> > !supportEmptyParas]> <![endif]><o:p></o:p></span></font><
> > /span></p>
> >
> > <p class=3DMsoAutoSig><!--[if supportFields]><font
> > color=3Dblack><span=20
> > style=3D'color:black'><span =
> > style=3D'mso-element:field-begin'></span><span=20
> > style=3D"mso-spacerun: yes"> </span>AUTOTEXTLIST \s
> > "E-mail=20
> > Signature" <span =
> > style=3D'mso-element:field-separator'></span></span></font><![
> > endif]--><f=
> > ont
> > color=3Dblack><span =
> > style=3D'color:black'>***************************************<
> > /span></fon=
> > t><font
> > color=3Dblack><span =
> > style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> > an></font><=
> > /p>
> >
> > <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:
> > 12.0pt;color:black'>Jonathan R. Karlen</span></font><font =
> > color=3Dblack><span
> > style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> > an></font><=
> > /p>
> >
> > <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:
> > 12.0pt;color:black'>Karlen Internet Solutions</span></font><font =
> > color=3Dblack><span
> > style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> > an></font><=
> > /p>
> >
> > <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:
> > 12.0pt;color:black'>Web Site and Application =
> > Development</span></font><font
> > color=3Dblack><span =
> > style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> > an></font><=
> > /p>
> >
> > <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:
> > 12.0pt;color:black'>[EMAIL PROTECTED]</span></font><font =
> > color=3Dblack><span
> > style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> > an></font><=
> > /p>
> >
> > <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> > face=3DArial><span =
> > style=3D'font-size:
> > 12.0pt;color:black'>http://www.karlen.com</span></font><font =
> > color=3Dblack><span
> > style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> > an></font><=
> > /p>
> >
> > <p class=3DMsoNormal><!--[if supportFields]><font
> > color=3Dblack><span=20
> > style=3D'color:black'><span =
> > style=3D'mso-element:field-end'></span></span></font><![endif]--><font
> > color=3Dblack><span style=3D'color:black'><![if =
> > !supportEmptyParas]> <![endif]></span></font><font
> > color=3Dblack><span =
> > style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> > an></font><=
> > /p>
> >
> > </div>
> >
> > </body>
> >
> > </html>
> >
> > ------=_NextPart_000_0004_01BFFD33.9974EEC0--
> >
> > --------------------------------------------------------------
> > ----------------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
