Make sure that for current datasession

SET TALK OFF

>I am very perplexed. I have a tool that saves PDFs as image fields in SQL Server. I know the tool and database work, because I can step through in design mode. The key to saving these files is to create an ADO recordset, AddNew(), and then save the actual file to the image field with:
>
>

>loFields.Item("Image").Value = CREATEBINARY(FILETOSTR(pcImageFile))
>

>
>It works great. Except when I have everything compiled into an EXE and then step through the EXE. If at that point I place the FILETOSTR() part in the Command Window and run it, I can see the file streaming to the console, dumping everything there (even shen I SET CONSOLE OFF).
>
>So, the issue must be with a SET command. In pure design mode it works, but in the executable (that has hundreds of SET commands), something is being set so that FILETOSTR() send the string to console output. On a 2 MB PDF file, that makes the executable look like it is hanging. Also, I am not sure the CREATEBINARY() is working right after that, as it seems to hang too.
>