Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE, SQL Pass thru
Message
From
10/05/2000 11:45:55
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
MSDE, SQL Pass thru
Miscellaneous
Thread ID:
00368170
Message ID:
00368170
Views:
56
? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (10)") works fine, but

lnVar=10
? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (lnVar)")

does not.

I guess it´s because the server does not know that lnVar=10?

VFP documentation is rather sketchy, or non existing, on this issue.

Does anybody know the solution.

Regards

Peter
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Next
Reply
Map
View

Click here to load this message in the networking platform