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