serial number

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date serial number Gill 12-21-2007  RE: serial number convoluted 12-27-2007  Re: serial number Craig 12-27-2007
Posted by Gill on December 21, 2007, 1:51 pm Please log in for more thread options I need to delet hundereds of old sold serial number because I need to shrink my DB. Is there way I can get script ? All the serials are under one item. -- Thank You Harjit SherGill /DBA Altaville Market 324 South Main st po box 370 Altaville CA 95221 Tel : 209-729-1410 vendaliajat@yahoo.com Posted by convoluted on December 27, 2007, 4:26 pm Please log in for more thread options Hi Gill - first confirm your item id by typing your serial item itemlookupcode in XXX below (keep the single quotes) select id from item where itemlookupcode = 'XXX' -- confirm and jot down the id assigned to the item - let's say its ID is123 The status field gets flagged with a "1" when the serial number has been sold - you could use this as a constraint in a where clause to only delete sold serial numbers - BACKUP THE DB FIRST then run delete from serial where itemid = 123 -- this will delete ALL serial numbers associated with that item id Have all of the serial numbers been sold? or are some still available for sale that you want to keep active? - hope this helps.... "Gill" wrote: > I need to delet hundereds of old sold serial number because I need to shrink > my DB. Is there way I can get > script ? All the serials are under one item. > > > > -- > Thank You > Harjit SherGill /DBA > Altaville Market > 324 South Main st po box 370 > Altaville CA 95221 > Tel : 209-729-1410 > vendaliajat@yahoo.com > > > Posted by Craig on December 27, 2007, 5:18 pm Please log in for more thread options Are you sure serial numbers are taking up that much space? It seems to me that serial numbers wouldn't take up that much room in the database. You would probably be better off deleting old journals, that way you would retain the sales info on all serial numbers. There has been a lot of discussion about deleting journals to free up space. Search the NG and you will get all the info you need. Craig > Hi Gill - first confirm your item id by typing your serial item > itemlookupcode in XXX below (keep the single quotes) > select id from item where itemlookupcode = 'XXX' > -- confirm and jot down the id assigned to the item - let's say its ID > is123 > > The status field gets flagged with a "1" when the serial number has been > sold - you could use this as a constraint in a where clause to only delete > sold serial numbers - > > BACKUP THE DB FIRST then run > delete from serial > where itemid = 123 > -- this will delete ALL serial numbers associated with that item id > > Have all of the serial numbers been sold? or are some still available for > sale that you want to keep active? - hope this helps.... > > "Gill" wrote: > >> I need to delet hundereds of old sold serial number because I need to >> shrink >> my DB. Is there way I can get >> script ? All the serials are under one item. >> >> >> >> -- >> Thank You >> Harjit SherGill /DBA >> Altaville Market >> 324 South Main st po box 370 >> Altaville CA 95221 >> Tel : 209-729-1410 >> vendaliajat@yahoo.com >> >> >> Similar Threads Posted Automate Serial NUmber transfer and Import Serial Number feature January 30, 2008, 10:26 am Serial Number December 1, 2007, 5:16 pm Serial Number December 6, 2007, 2:48 pm serial number can not be created in POS June 29, 2005, 12:51 pm Dongle Serial Number August 24, 2005, 7:21 pm How can I change a serial number? February 17, 2006, 5:02 am serial number search August 1, 2006, 2:53 am Serial Number Transfers October 26, 2006, 10:06 am Delet serial number October 29, 2007, 11:39 am Receipt with Serial Number November 5, 2007, 4:41 pm