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:
00888930
Views:
15
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform