Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass-Through On SQL Server, Update On Memo Field
Message
From
05/11/1998 12:12:20
 
 
To
05/11/1998 10:58:26
Roberto Cysne
Banco do Nordeste S.A.
Fortaleza, Brazil
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00154819
Message ID:
00154881
Views:
22
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
Previous
Reply
Map
View

Click here to load this message in the networking platform