'CREATE SQL VIEW' will not display a BROWSE window but a query w/o IN/INTO clause will. IOW, If somehow you're loosing the first part of your command 'create sql view bar as' then 'select * from history' will create a BROWSE window. Can you post a piece of actual code that causes the problem?
>Ok a Quick Question
>
>I do the following
>
>create Database foo
>create sql view bar as select * from history
>
>History is a local free table.
>
>what setting \ comand would cause the create SQL View to Display a browse window on the view from an EXE? It's Obviously something I'm doing which is not obvious to me :)
>
>if I did this as a separate PRG (as opposed to a part of my app) it works fine
>
>Thanks
--sb--