>I am trying to get a procedure to insert blob information into a sql server table. I can get a small text file to insert but when I try an xl file ( or something else) I get a type mismatch from the sp that I have created. I have read the file to a memory varialbe (filetostr()) and passed that to the stored procedure. Is VFP 9 truncating the value that is being passed or do I need to try a different approach to inserting the information in SQL other than an INSERT statement?
>
Hi Kelly,
You've to convert file to hexbinary. It limits the size of the file to around 8MB
lcHex = STRCONV(FILETOSTR(lcFileName),15)
I would create a cursor with one blob field, use APPEND MEMO to put a file into it and than use it as parameter to your SP.
--sb--