General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Cetin,
I'm getting an error when I try to insert more than 10 fields using SQLExec.
lnsuccess = SQLEXEC(gnConnHandle, "INSERT INTO Sync_Box (;
Ordernum, box, status, shiplist, charges, ship_date, inpart, hold_date, custnum, trackingno, box_id, ship_to, ship_via, ship_when) ;
VALUES (;
?Order, ?box, ?status, ?shiplist, ?charges, ?ship_date, ?inpart, ?hold_date, ;
?custnum, ?trackingno, ?box_id, ?ship_to, ?ship_via, ?ship_when)")
If I take out any 4 fields it works great. What am I doing wrong?
Many thanks.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only