Hi Bob,

I've noticed that you participate in the Codebook forum at leafe.com. Did you try this approach on Codebook bizobj? I was hoping to use the article you mention below to modify my search criteria on my bizobj and wonder if you have any words of advice.

Paul de Niverville


,
>
>do you have access to the August 98 issue of FoxTalk... an article on Query By Form tells you how to replace the WHERE of a view on the fly like you want to do... you are pretty close.
>
>I sort of modified the approach from the article...the article assumes that each user has there own personal copy of the .DBC with the views in it.
>
>Basically, what I do is create the view in the view designer without a WHERE.
>
>Then... what you can do is use the view with nodata
>
>No... all you have to do is query the data, using your programatically built where, and append the records to the view.
>
>You can also get the select SQL from the view so you don't have to recreate it...
>
>cWhere = 'WHERE ...'
>
>use MyView nodata
>
>cSQL = cursorgetprop('SQL','MyView')
>
>cQueryString = cSQL + cWhere
>
>&cQueryString INTO CURSOR MyWhere NOFILTER
>
>sele MyView
>append from dbf('MyWhere')
>use in MyWhere
>
>It is a kludge, but it seems to work.
>
>BOb