Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Into Syntax
Message
 
To
17/01/2005 16:50:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00977860
Message ID:
00977975
Views:
40
>I am trying to pass an SPT Insert Into command. How do I pass a logical parameter?
myInsert = "INSERT INTO MyTable (.....) VALUES (.....,"+IIF(MyLog,"1","0")+",....)"
SQLEXEC(sqlH, myInsert)
....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform