Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use ? in variables for UPDATE/INSERT statements?
Message
 
To
26/06/2007 12:39:35
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
01235643
Message ID:
01235722
Views:
14
>Hi Cetin..
>
>=ExecuteSql( - is nothing more than =SQLEXEC(gnc, ???) where gnC is the ODBC connection reference

UPDATE: MY MISTAKE!!!
I didn't close the brackets ;o(
That works for me:
CREATE CURSOR ctsTest (Id C(6), FirstName C(20))
INSERT INTO ctsTest VALUES ('aaaaaaaa',[don't know ?])
lnSQL = SQLSTRINGCONNECT([Driver=SQL Server;Server=Boris;DataBase=Test;Trusted_Connection=yes])
? SQLEXEC(lnSQL, [INSERT INTO TestMe (Id, FirstName) VALUES (?ctsTest.Id,?ctsTest.firstname)])
In the Test DATABASE I have table named TestMe with (Id char(6) NULL, FirstName varchar(20) NULL)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform