>Wayne:
>
>You don't send any parameters to the View. You build a SQL string from a query form or something similiar, then pass it to a prg that drops the view from the dbc (local) then recreates the view with a the new WHERE clause. In the DE you must close and reopen the tables in order for it to take effect.
>
>It is especially useful in C\S application. The user has complete control over the data brought down from the server.
>
>Charlie
It really sounds like you would be better off using pass through... then you could create your select statement on the fly.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown