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