General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only