Run from the command window -- do home() + "tools\gendbc\gendbc" to get an ouput to a PRG file of all the code needed to create your DB, tables, views, connections, indexes, etc. MODI COMM that PRG file. Look for the code that creates that view.

I usually copy that code to my own PRG file where I maintain all code needed to create views. I can then modify and run that code for any of the views. Specifically, you can use DBSetProp() to change the data type for a field in a view.

>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