Hi,

Stuck again!

I created a remote view. All output fields are fine except that an SQL field varbinary(3) is being converted to VFP MEMO(Binary). I need it to be converted to VFP CHAR(Binary). I tried the View Designer - got the FVP CHAR(Binary) but I can't get my filter to work. Hard coded the CREATE SQL VIEW; filtered worked but crested VFP MEMO(Binary). Could not how to tell the SELECT to Output VFP CHAR(Binary).

As I tried to explain I can't seem to find a way to accomplish it.

How would you HARD CODE the CREATE SQL VIEW for the remote connection;

SELECT sql.field as new_field vbinary(6) ;

Thanks in advance!
Roland