I have a bit of a techy question. I am thinking of doing a little tweek involving updating certain timers automatically. Not (yet) knowing Jim - I am inclined to do it with a simple SQL triggered by a cron job, but wanted to check if there are any fundamental problems with what I am thinking of doing.
I was planning to take the record from tbl_reservation (with suitable checks that it is not already in pending for a different update) and create a record in pending (in rsvp) to update things like the path. Having done some changes in WebIf and looking at the pending record created, I think I am on the right lines, but don't know if there are more complex issues that would need dealing with for any of the series links or anything.
My couple of questions are:
1) If I create a record in pending which is an exact copy of the tbl_reservation record, am I right in thinking that it would be a non-change to the timer with no ill effects? Thus making an exact copy with the path changed will update the path with no other ill effects to the timer.
2) I see that a path change uses an action of 4. Is there a list somewhere of what the valid values are for the action column in pending?
3) I see that szevtname always has a character at the start (which isn't displayed in the table view in WebIf and I haven't checked the acsii value yet) and sometimes has i7 before the name. Just out of interest, is there an explanation of those characters anywhere?
Cheers,
Rowan.
I was planning to take the record from tbl_reservation (with suitable checks that it is not already in pending for a different update) and create a record in pending (in rsvp) to update things like the path. Having done some changes in WebIf and looking at the pending record created, I think I am on the right lines, but don't know if there are more complex issues that would need dealing with for any of the series links or anything.
My couple of questions are:
1) If I create a record in pending which is an exact copy of the tbl_reservation record, am I right in thinking that it would be a non-change to the timer with no ill effects? Thus making an exact copy with the path changed will update the path with no other ill effects to the timer.
2) I see that a path change uses an action of 4. Is there a list somewhere of what the valid values are for the action column in pending?
3) I see that szevtname always has a character at the start (which isn't displayed in the table view in WebIf and I haven't checked the acsii value yet) and sometimes has i7 before the name. Just out of interest, is there an explanation of those characters anywhere?
Cheers,
Rowan.