Re: SOT: Aqua Studio / Oracle
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 > value through a trigger I would have a trigger named TRG_PATCHES -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229120 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
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, 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; > > Do you know whether my sequence should have a semi-colan at the end? Also, > the actual field name is called PATCHID, should i call this sequence > something else? > > If i take off the semi-colan and give the seq a random name it seems to > come up with no errors but is there a way i can see whether it actually did > anything? > > Thanks for your time, > > Saturday > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
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; If you don't want a max value, use the NOMAXVALUE attribute instead of the MAXVALUE with that number. > > Do you know whether my sequence should have a semi-colan at the end? Also, > the actual field name is called PATCHID, should i call this sequence > something else? > In AquaData, no, you don't want the semi-colon at the end. > If i take off the semi-colan and give the seq a random name it seems to come > up with no errors but is there a way i can see whether it actually did > anything? > SELECT patchid.nextval FROM dual > Thanks for your time, > Your welcome. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229055 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
raptor...still SOT(WAS Re: SOT: Aqua Studio / Oracle)
fyi, Oracle has a new tool called Raptor http://www.oracle.com/technology/products/database/project_raptor/index.html I have been using it for a week now...nice. DK 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; > > Do you know whether my sequence should have a semi-colan at the end? Also, > the actual field name is called PATCHID, should i call this sequence > something else? > > If i take off the semi-colan and give the seq a random name it seems to come > up with no errors but is there a way i can see whether it actually did > anything? > > Thanks for your time, > > 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 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; > > > > but i have no idea where i should run that script. > > > > Is there a way to create a seq via the GUI? (I'm missing Enterprise > > Manager!) > > If you're talking about opening up a query window, select the server, > the database and the table on the left and hit CTRL-Q (or right click > and select New Query Window) > > Hatton > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
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 patchid.nextval from dual;" to see if it worked properly. Also, in the tool that I use, there are two ways to execute - either via script or as a statement. If you're executing as a statement, you can't have the semi-colon. As script you can. In my tool, you get an error that says, "invalid character" if you try to execute something as a statment that's actually a script. I use TOAD, by the way, which has a free version. Tis very nice, I highly recommend it. As an aside, you do realize that your'e not creating an auto-incrementing field ala access or sql server, right? You're creating a sequence that you can use to populate the field. -d 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; > > Do you know whether my sequence should have a semi-colan at the end? Also, > the actual field name is called PATCHID, should i call this sequence > something else? > > If i take off the semi-colan and give the seq a random name it seems to > come up with no errors but is there a way i can see whether it actually did > anything? > > Thanks for your time, > > Saturday > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229052 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
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; Do you know whether my sequence should have a semi-colan at the end? Also, the actual field name is called PATCHID, should i call this sequence something else? If i take off the semi-colan and give the seq a random name it seems to come up with no errors but is there a way i can see whether it actually did anything? Thanks for your time, 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 > 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; > > but i have no idea where i should run that script. > > Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) If you're talking about opening up a query window, select the server, the database and the table on the left and hit CTRL-Q (or right click and select New Query Window) Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229050 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
> 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; > > but i have no idea where i should run that script. > > Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) If you're talking about opening up a query window, select the server, the database and the table on the left and hit CTRL-Q (or right click and select New Query Window) Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229045 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Aqua Studio / Oracle
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; but i have no idea where i should run that script. Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) Thanks, Saturday ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229043 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54