>One way is to have a completely dynamic where clause, e.g.,
>CREATE SQL VIEW lvMyView AS ;
> SELECT * FROM parcel ;
> WHERE &?lcPermitSearch
>
>Notes:
>The "&" goes in front of the "?"
>
>This cannot be done in the view designer.
>What you can do with the View Designer, however, is add the fields as you would want them, set the updatability of each, etc., then run GenDBC[X] -- actually GetView() from GenDBC[X] -- to get the definition of the view.
>Then you can add the
WHERE &?lcPermitSearch
in the code and recreate the view.
>
>Then all you would have to is USE or REQUERY() the view instead of the SELECT.
>
Hi Trey,
I'm somewhat 'view challenged' , so please forgive my ignorance in this area. With this approach is the CREATE SQL VIEW myview AS... still going to be in the DBC or am I just using the DBC to do some of the work for me (write some code for, send updates etc.)and then capture it with GENBDC and place it in a form method somewhere. Also, I couldn't find GetView(). As you can tell, I'm not quite there yet...but having fun!
Thanks for your help.
John