RE: LIST OF SQL QUERIES FOR RMS

Posted by ekrvcr on April 6, 2008, 10:16 pm

Please log in for more thread options

BD try the following, i found it on the Retail Hero site.
THE SCRIPT SETS BARCODE FORMAT FOR ALL ITEMS

Change Barcode format number as the following:

0 = None
1 = 2 of 5
2 = Interleaved 2 of 5
3 = 3 of 9
4 = Codabar (Rationalized)
5 = 3 of 9 (extended)
6 = Code 128A
7 = Code 128B
8 = Code 128C
9 = UPC-A
10 = MSI (Plessey)
11 = Code 93
12 = Extended Code 93
13 = EAN 13
14 = EAN 8
15 = PostNet

*/

UPDATE Item SET BarCodeFormat=5

"BD" wrote:

> IS THERE A LIST OF SQL QUERIES FOR USE WITH RMS. FOR EXAMPLE HOW TO

> CANGE BARCODE TYPES WITH A QUERY ECT.

> ANY HELP WOULD BE APPRICIATED

Posted by Jon on April 8, 2008, 12:20 am

Please log in for more thread options

BEFORE you begin usine Management Studio to change the database make sure you
read some books. The last post by Ekrvcr is correct, but test your query
first with the select statement. You will need to use a where statement if
you don't want to change the entire database. Remember to backup the db
first. Good Luck

"ekrvcr" wrote:

> BD try the following, i found it on the Retail Hero site.

> THE SCRIPT SETS BARCODE FORMAT FOR ALL ITEMS

> Change Barcode format number as the following:

> 0 = None

> 1 = 2 of 5

> 2 = Interleaved 2 of 5

> 3 = 3 of 9

> 4 = Codabar (Rationalized)

> 5 = 3 of 9 (extended)

> 6 = Code 128A

> 7 = Code 128B

> 8 = Code 128C

> 9 = UPC-A

> 10 = MSI (Plessey)

> 11 = Code 93

> 12 = Extended Code 93

> 13 = EAN 13

> 14 = EAN 8

> 15 = PostNet

> */

> UPDATE Item SET BarCodeFormat=5

> "BD" wrote:

> > IS THERE A LIST OF SQL QUERIES FOR USE WITH RMS. FOR EXAMPLE HOW TO

> > CANGE BARCODE TYPES WITH A QUERY ECT.

> >

> > ANY HELP WOULD BE APPRICIATED