Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transferring VFP memo to SQL...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00888843
Message ID:
00889081
Views:
15
Sylvain,

The parameters aren't evaluated but passed to ODBC. For SQL Server sp_executesql system stored procedure used in this case as result.

>Hi Sergey,
>
>I'm not knowing much in SPT but does this parameter tells SPT to evaluate the variable/field ?
>
>Thanks
>
>>>Transferring some records from VFP to SQL 2000, using SQL pass through. The record contains a memo field with customer service notes. Some of the notes contain ‘---‘ and carriage returns and line feeds. How can I transfer this using SQL pass through?
>>
>>You can use SPT parameters (?).
TEXT TO lcSql TEXTMERGE NOSHOW
>>INSER INTO mytable (..., sqltext,...) VALUES (..., ?mytable.mymemo,...)
>>ENDTEXT
>>lnResult = SQLEXEC(lnConn, lcSql)
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform