Hi!

Are you sure that field is image field type? I just searched MSDN and read the INSERT command manual. Text pointers are mentioned there. Try to look there.

Also, did you try to insert record using append blank/populate fields/tableupdate()? Would it work for you?

>I am succesfully using an offshoot of Vlad Grynchyshyn's FAQ#7995 technique for moving binary data back and forth from SQL 2K to Desktop via SPT. It works great for word, excel, and all other files I've tried until now.
>
>The problem is, that when trying to upload an .exe (a VFP exe actually), I get a SQL error saying that:
>
>"Only text pointer are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image column in a work table."
>
>I should note that this happens ONLY on INSERT where I'm using SPT with a

(myimage field) values (?mygenfield)

clause. An UPDATE statement from the cursor using tableupdate() works fine.
>
>Any ideas anyone?
>TIA,