Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use ? in variables for UPDATE/INSERT statements?
Message
 
À
26/06/2007 12:39:35
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7
Divers
Thread ID:
01235643
Message ID:
01235722
Vues:
13
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform