Re: Oracle and MS-Access sequence problems

From: Bruce Pihlamae <bpihlama_at_NLA.GOV.AU>
Date: Fri, 19 Jan 1996 08:53:36 +0000
Message-Id: <9601182205.AA26577@alice.jcc.com>

> We want to be able to use Oracle's Sequence generator to
> create unique ID's on row-inserts, but have been unable to get MS-Access =
> to
> recognize any way to accomplish this - it doesn't recognize the SQL state=
> ment
> with the "<sequence>.nextval" in it.
>
> Any ideas ??

Pass across a NULL (or special eg negative) value and have a trigger on the  Oracle table
populate the field with the sequence number.

Bruce...

---

   T T T T T T T T        Bruce Pihlamae
   I I I I I I I I        bpihlama_at_nla.gov.au
   I I I I I I I I        National Library of Australia
   T T T T T T T T        Phone: +616 262-1480
  -----------------       Fax:   +616 273-2116
 ===================

 "If you swallow a live frog first thing in the morning;   nothing worse will happen to either of you that day." Received on Thu Jan 18 1996 - 17:05:55 CST