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 999999999999999999999999999 > 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