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.
LIST OF SQL QUERIES FOR RMS
Apr 05, 2008
3 Replies
Hi there,
There is no list of SQL queries for use whit RMS. You must create them on your own, depending on your needs. What I would recomend You is to download some of the free manuals of transac-SQL or use the SQL Query Analizer Help and look some of the master-data tables in the RMS DataBase. It is not difficult to start creating queries...
Regards, Antonijo
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:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required