When using SQLEXEC command to return a binary field from a SQL Server it comes back as a gen data type. Trying to save the field to a string, so I can use the STRTOFILE command but I get the error when using the following command.


SqlServer = SQLCONNECT("sqlServer", "userid", "Password")
rc = SQLEXEC( sqlServer, "SELECT binaryField From sqltable", "mycursor")

lcSting = myCursor.Binaryfield <-- Error


I think the problem is, the binary field is around 8000 char, and also has nulls in it.

Is there another way to retieve binary fields from SQL Server?

I need to be able to read/change the field and update the table on the SQL Server.

Thanks for the help

Rex A. Walters