>Hi all
>
>I have a data field in my table and i want a parmeterized view,like to get the FROM date and TO date,and pull up records for the dates entered by the user.how to do this ?
>
>mytable.datefield is of Datatype date
First, go to VFP Help and search for Views under the Index tab. Scroll down to Parameterized. Click on that to display the subject. You will be taken to Chapter 8: Creating Views. In that subject, go down to Creating a Parameterized View.
After you create your view, I would create a form that prompts the users for the begin and end dates. In the DataEnvironment, add your view and set the NoDataOnLoad property to true. You will also need a SET TALK OFF in the BeforeOpenTables methos.
In the OK button, set your view parameters to the values in your begin and end date controls. Then issue a REQUERY('MyView') command to populate the view with the matching records.
Mark McCasland
Midlothian, TX USA