1. Home
  2. Point-Of-Sale Software
  3. LIST OF SQL QUERIES FOR RMS

LIST OF SQL QUERIES FOR RMS

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.

Reply to
BD
Loading thread data ...

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

Reply to
Antonijo Todoro

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:

Reply to
ekrvcr

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.