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