mark check in click event

[channelmaster]

Hello! Can anyone help with this problem? How can I check mark records when I click a button "cancel orders" when orders are expired or not redeem? My table is ORDER.DBF and the fields are:
date_order---date
date_cancel---date
cancel----logical
I used the variable; lCancel=date_order + 60 &&60 days that will replace in the "date_cancel" field
the scenario is like this; in the grid,when orders are not redeem, I want to click the cancel button to check mark the "cancel" fields all records that have met the "date_cancel" fields. How can you do this? BTW, the fields in the "cancel" is readonly. My problem is how to check mark it when clicking the cancel button and look for the records that is "60 days" due and mark it check automatically. Thanks

rene

 

[Mike Gagnon]

If you are using a grid, you would have to put a checkbox as the currentcontrol of the logical field column. And make the checkbox the currentcontrol. Make that column sparse. And you could use in the click event something like:

UPDATE myTable SET CANCEL = .T. WHERE DATE_CANCEL=DATE()

Mike Gagnon