>Hi Larry ---
>
>What error do you get? Anyway, try using Erik Moore's eView utility, available here in the Files section, or just write the code yourself as:
>
>OPEN DATA MyDatabase
>CREATE SQL VIEW myView CONNECTION MyCOnnection AS SELECT SPACE(1) AS myColumn1,* FROM ExternalDataSource
>
>
>>How do I go about adding and extra column to my remote views that corressponds to SELECT *, ' ' as extracol1, .f. as extracol2 FROM mytable?
>>
>>In the remote view designer, it lets me add the expression, but when I run the view it errors.
>>
>>TIA
>>Larry

The SPACE(X) worked for the char column, but for the logical column I gat a "connectivity error, syntax bad near AS'...or something like it