Once the following statement is executed:

create sql view agents_view as select * from a

I can DO FORM AGETNSFORM which displays the view in the form.

How do I make the connection between subsequent select statements to view the new data in the same form? Select wants to display its data in a BROWSE window. Do I have to CREATE SQL VIEW ... each time and then DELETE VIEW to get different data?

e.g. select * from a where a.contactid = "KOGR"