Hi!

Take a look to the FAQ#7995.

Good luck!

>I would like to store various files of various types in a blob on my sql server.
>
>after I generated the necessary table on the server the vfp cursor creates a duplicate cursor of the blob fields as General Fields.
>
>so far I can get the fiels into the general fields, but sending over to the Sql server the sql command to update the record, has got me lost.
>
>what I think I am missing is the ability to read the data from a general field directly .
>
>I cant do a m_data = mycursor.generalfld and have that work.? but if i browse the cursor, the file(for testing I am using a pdf file) is there sitting in the general field.
>
>so I guess my quesiton is, how does one take data from a general field, and read it into a variable, so I can get it into a sql type command string.?
>
>My first thought would be not to save in a general field alltogether, and just read the file from filetostr() function, and send that directly to the sql server.
>
>Has anyone tackled this one yet ?
>
>bob Lee