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,
Ken B. Matson
GCom2 Solutions