i have a label designed and i want to fix a barcode so that it can be the same for all articles in the system.
Barcode Fixed
Oct 10, 2007
1 Replies
If you mean that you want to set all the items in the database to have the same barcode that is displayed on the Item Properties page then the following will do the job.
---------------------------------
UPDATE Item SET BarcodeFormat = 1
---------------------------------
Substitute the BarcodeFormat number depending on which type of barcode from the following list
0 = NONE 1 = 2 of 5 2 = Interleaved 2 of 5 3 = 3 of 9 4 = Codabar 5 = 3 of 9 (extended) 6 = Code 128A 7 = Code 128B 8 = Code 128C 9 = UPCA 10 = MSI 11 = Code93 12 = Extended Code93 13 = EAN13 14 = EAN8 15 = PostNetRegards Michael (Brisbane, Australia)
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required