SQL Basics
 

 

Because the SQL command dialog allows you to make large-scale changes to a database, it can be a very powerful and dangerous tool. If you are not familiar with the SQL language, you should stay away from this area.

SQL requires a knowledge of the underlying table and field names. The following is a list of the tables and fields in the database.

BACKUP CUSTOMERS
BOXNO INTEGER CODE CHAR(8) NOT NULL
PRODUCT CHAR(6) NAME CHAR(20)
SERIAL CHAR(11) ADDRESS CHAR(200)
WHOLE SMALLINT SHIPADDRESS CHAR(200)
PIECES SMALLINT ALTADDRESS CHAR(200)
UNITS SMALLINT CONTACT CHAR(20)
DATECODE DATE PHONE CHAR(20)
CUSTOMER CHAR(6) FAX CHAR(20)
LOT SMALLINT OTHER CHAR(20)
FARM CHAR(6) EMAIL CHAR(20)
CAGE SMALLINT SALESMAN CHAR(20)
BOXTYPE SMALLINT SHIPPER CHAR(20)
LABELWEIGHT NUMERIC(9, 2) PACKAGE CHAR(8)
GROSSWEIGHT NUMERIC(9, 2) LABEL CHAR(8)
NETWEIGHT NUMERIC(9, 2) LABEL_L1 CHAR(30)
TIMESTAMP DATE LABEL_L2 CHAR(30)
PRICE NUMERIC(9, 2) LABEL_L3 CHAR(30)
PACKSTATION SMALLINT LABEL_L4 CHAR(30)
OPER CHAR(6) LABEL_L5 CHAR(30)
STATUS SMALLINT LABEL_L6(30)
ORDERID CHAR(10) BXS_PALLET SMALLINT
SLIPID CHAR(10) STATIONS CHAR(20)
VOUCHERID CHAR(10) LABEL_ADD CHAR(200)
INVOICEID CHAR(10)  
INVENTORY CHAR(8)  
DATESTR CHAR (11)  
PVALUE NUMERIC(9, 2)  
CURRENCY SMALLINT  

                                                                 

                                                      Phone: (506) 857-0909
                                                        Fax: (506) 858-9271
                                                  Email: advatek@nbnet.nb.ca