Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Pass-Through On SQL Server, Update On Memo Field
Message
De
05/11/1998 12:12:20
 
 
À
05/11/1998 10:58:26
Roberto Cysne
Banco do Nordeste S.A.
Fortaleza, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00154819
Message ID:
00154881
Vues:
21
Using the inverted quotation marks really did not work well I was having problems debugging it so I used the folling lines that works well. Just thought you would like to know.

lcSql = "UPDATE Referenc Set rf_ordr = '" + ALLTRIM(References_main.rf_ordr) + "',";
+ "rf_para = '" + ALLTRIM(References_main.rf_ordr) + "',";
+ "rf_Title = '" + ALLTRIM(References_main.rf_Title) + "',";
+ 'rf_text =?References_main.rf_text,';
+ 'rf_inter =?References_main.rf_inter,';
+ 'rf_cmnt =?References_main.rf_cmnt';
+ " WHERE rf_num = " + ALLTRIM(STR(references_main.rf_num))
lnTest = SQLPREPARE(THIS.ln130Checklist,lcSql)

Darren Mc Dowell
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform