Updating all records

Scriptcase 8 Discussion
#1

This may appear to be a simple one but I am struggling to find the best way to achieve the following, and any assistance / examples would be most appreciated …

I have a table which through a blank form I have a button called “month-end” on selecting the button I wish to update a status field for all records which meet a specific date criteria with a value of ‘2’

please could someone advise the best way to achieve this

Thanks in advance.

#2

[QUOTE=awayman;39011]This may appear to be a simple one but I am struggling to find the best way to achieve the following, and any assistance / examples would be most appreciated …

I have a table which through a blank form I have a button called “month-end” on selecting the button I wish to update a status field for all records which meet a specific date criteria with a value of ‘2’

please could someone advise the best way to achieve this

Thanks in advance.[/QUOTE]

I would redo this into a control form. Then you can create a button of type php and apply the required code to the button. For update of the table you can use the regular sql macro’s.

#3

Thank you. Issues like these sometimes + structural rigidity make you wonder the true productivity benefits RAD tools really give. Hard to tell so I’m still a “scriptcaser”.