>I am trying to get a procedure down to insert blob data into either a VFP table or a SQL server database (don't really care for now but it will eventually all go to SQL). I was first instructed to save the file in question to a memory variable and pass the value to a stored procecdure. I almost got it to work but have been pulled off for a while and have misplaced my notes on how I got there to begin with.
>
>So 1) How do I save a file (lets say an XL) file to the memory variable? and 2) Is there something more than the basic gather (memo?) command for the VFP end and straight insert on the SQL end?
>
>Thanks in advance
>Kelly
I just started with this and not so sure, but:
1. You can get the file as a memory variable easy just use FILETOSTR() function:

cmyBinaryFile = FILETOSTR("xxxxxx.XLS")

2. Not tryed but in VFP9 CA class there is a MapBinary property, check HELP fo it. and you can do the same with CURSORSETPROP("MapBinary"....)