Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC won't Insert data
Message
From
06/01/2008 09:11:50
 
 
To
06/01/2008 09:03:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01279605
Message ID:
01279740
Views:
18
sorry this still doesn't work. What am I missing?

lcDSNLess="server=RIXON-6A0C5C112\SQLEXPRESS;driver={SQL Server};database=PHOTOEYE;Trusted_Connection=Yes"

x = SQLSTRINGCONNECT(lcDSNLess)

use SyncBoxQuery

SCAN NEXT 20
text to m.lcSQL
INSERT INTO Sync_Box (;
shiplist) ;
VALUES (;
?SyncBoxQuery.shiplist)
Endtext
lnsuccess = SQLEXEC(m.gnConnHandle, m.lcSQL)
? lnsuccess
endscan


* lnsuccess is -1 each time.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform