Re: SOT: Aqua Studio / Oracle

2006-01-10 Thread James Holmes
I do exactly the same. On 1/11/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > I typically prepend my sequence names with SEQ_ and then the table that I > intend to use it with. So if for table PATCHES I would call mine > SEQ_PATCHES. Then if I was populating that PATCHID field with the sequence >

Re: SOT: Aqua Studio / Oracle

2006-01-10 Thread Aaron Rouse
I typically prepend my sequence names with SEQ_ and then the table that I intend to use it with. So if for table PATCHES I would call mine SEQ_PATCHES. Then if I was populating that PATCHID field with the sequence value through a trigger I would have a trigger named TRG_PATCHES On 1/10/06, Stua

Re: SOT: Aqua Studio / Oracle

2006-01-10 Thread Dave Carabetta
On 1/10/06, Stuart Kidd <[EMAIL PROTECTED]> wrote: > Thanks for that Hatton. I managed to get the query window open and put a > query inside but seem to get some errors. > > CREATE SEQUENCE PATCHID > MINVALUE 1 > MAXVALUE 999 > START WITH 1 > INCREMENT BY 1 > CACHE 20;

raptor...still SOT(WAS Re: SOT: Aqua Studio / Oracle)

2006-01-10 Thread Douglas Knudsen
gt; > Saturday > > > From: "C. Hatton Humphrey" <[EMAIL PROTECTED]> > Sent: Tuesday, January 10, 2006 11:40 AM > To: CF-Talk > Subject: Re: SOT: Aqua Studio / Oracle > > > I don't know whether anyone has use

Re: SOT: Aqua Studio / Oracle

2006-01-10 Thread Deanna Schneider
I'm not familiar with that particular tool. But, it shouldn't matter that you have a column named patchid. It would matter if you had another object called patchid (table, trigger, proc, etc). In which case you should get an error about it already existing. You can just run the query "select patch

Re: SOT: Aqua Studio / Oracle

2006-01-10 Thread Stuart Kidd
, Saturday From: "C. Hatton Humphrey" <[EMAIL PROTECTED]> Sent: Tuesday, January 10, 2006 11:40 AM To: CF-Talk Subject: Re: SOT: Aqua Studio / Oracle > I don't know whether anyone has used Aqua Studio before but in case you have &

Re: SOT: Aqua Studio / Oracle

2006-01-10 Thread C. Hatton Humphrey
> I don't know whether anyone has used Aqua Studio before but in case you have > then maybe you can help. > > I am trying to create a field with an incremental ID. I found this clever > script: > > CREATE SEQUENCE supplier_seq > MINVALUE 1 > START WITH 1 > INCREMENT BY 1 > CACHE 20; > >

SOT: Aqua Studio / Oracle

2006-01-10 Thread Stuart Kidd
Hi guys, I don't know whether anyone has used Aqua Studio before but in case you have then maybe you can help. I am trying to create a field with an incremental ID.  I found this clever script: CREATE SEQUENCE supplier_seq     MINVALUE 1     START WITH 1     INCREMENT BY 1     CACHE 20;