>I am using MSSQLServer 2000 and using the following command to retrieve a record which contains a text field in the SQLServer table:
>
>lccmd = "Select * from messages where lactive = 1"
>lnsuccess = SQLEXEC(nhandle,lccmd,"mycursor")
>
>When I access mycursor the text field contains the usual foxpro "memo" designation but I cannot put my cursor into the field or open it and the lower case "m" in memo indicates there is no value in the field although the SQL table does contain a short line of text.
>
>What do I need to do to have the SQLEXEC also pull in the text field value?
>
>Paul Montgomery
Hello Paul
I use text and ntext with strcovert from VFP to MS SQL and back from
MS SQL to VFP
I put incide it binary files like exe for new VFP application
I read file at VFP client with fopen, fread into some variable,
put it to new variable with strconvert and use sqlexec with insert command and
question mark with this second variable
When I get sqlexec with select on thge table with text
I again use strconvert to take cursor field into VFP variable
Thus way I keep in text field 2 bites analog of VFP variable
and put it back to 1 bit variable on VFP client
Vladimir