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.
- posted
16 years ago
Barcode Fixed
Loading thread data ...
- Vote on answer
- posted
16 years ago
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)