Also, (haven't seen this posted yet) to more closely mirror Autonumber / Identity type, you can define a trigger for that table and column, that would automatically get the next value from the sequence on insert, and disallow updates for that column. I think the Access upsizing wizard would create this for you, so you can see the syntax.
- David L, TeraTech Bryan Stevenson wrote: >Didn't we just answer this?? > >Anyhoo...no. There is the concept of sequences though. > >To quote Tony: >"Not directly. But you can create a SEQUENCE. Then you use the value from >that sequence in your query: > >INSERT INTO table >(pk,value,value) >VALUES >(sequencename.nextval,'value','value')" > >Bryan Stevenson >VP & Director of E-Commerce Development >Electric Edge Systems Group Inc. >p. 250.920.8830 >e. [EMAIL PROTECTED] >--------------------------------------------------------- >Allaire Alliance Partner >www.allaire.com > >----- Original Message ----- >From: "sam komolafe" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, January 03, 2002 8:52 AM >Subject: Database AutoNum column > > >>Hi guys >> >>Is there an autonum feature in oracle 8i, if so how do I define it? >> >>Thanks >>Sam komolafe >> >> >> > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
