>Sorry, it should be the following, but it still fails.
>
>use SyncBoxQuery
>SCAN NEXT 20
>text to m.lcSQL noshow
> INSERT INTO Sync_Box (;
> shiplist, charges, ship_date, inpart, hold_date, custnum, box_id, ship_to, ship_via, ship_when) ;
> VALUES (;
> ?shiplist, ?charges, ?ship_date, ?inpart, ?hold_date, ?custnum, ?box_id, ?ship_to, ?ship_via, ?ship_when)
>ENDTEXT
>lnsuccess = SQLEXEC(m.gnConnHandle, m.lcSQL)

BTW move the text...endtext outside scan (and precompile the query with SQLPrepare):

text to m.lcSQL noshow
	INSERT INTO Sync_Box (
		shiplist, charges, ship_date, inpart, hold_date, custnum, box_id, ship_to, ship_via, ship_when) 
	 VALUES (
		?SyncBoxQuery.shiplist, ?SyncBoxQuery.charges, ...)
ENDTEXT

use SyncBoxQuery
SQLPREPARE(m.gnConnHandle, m.lcSQL)
SCAN NEXT 20
  lnsuccess = SQLEXEC(m.gnConnHandle) && till query changes it is m.lcSQL
endscan

PS: Remove semicolons. To SQL server ; denotes end of statement. Use a single ; at end or none.
Cetin