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
>
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
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;
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
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
,
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
&
> 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;
>
>
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;
8 matches
Mail list logo