I have a problem with a post operation that will not execute properly when run from within a script using a run.silent statement. I have nine condominium account dbf tables that store expense and budget information.
I have a budget dbf table which has 9 budget fields, one for each of the nine account dbf tables. This table is used to allocate the budget amounts by different formulas across the 9 fields.
A script is run from a button on a form to run an operation that will clear the existing each of the nine account dbf table budget fields and post a new budget amounts from the budget dbf table. When the script is run each account dbf file budget fields are cleared and the new budget field is posted using a replace action.
The problem is that one of the post operations will not post when run in a group of nine tables using a the script. It will run OK when run from the control panel and also when run singly in the script. I have changed the position in the group of nine and it still will not run the post. The clear operation always executes whether done singly of in a group of nine.
I have recreated the post several times and always get the same behavior when run from the scripts in the group of nine.
Well, today 3-19-02, I decided to give it one last try. I deleted and recreated the related account dbf table. I had to also recreate the operations because they went with the dbf table. Guess what? The whole thing works without a problem!
BTY this is ver 4.5
I have a budget dbf table which has 9 budget fields, one for each of the nine account dbf tables. This table is used to allocate the budget amounts by different formulas across the 9 fields.
A script is run from a button on a form to run an operation that will clear the existing each of the nine account dbf table budget fields and post a new budget amounts from the budget dbf table. When the script is run each account dbf file budget fields are cleared and the new budget field is posted using a replace action.
The problem is that one of the post operations will not post when run in a group of nine tables using a the script. It will run OK when run from the control panel and also when run singly in the script. I have changed the position in the group of nine and it still will not run the post. The clear operation always executes whether done singly of in a group of nine.
I have recreated the post several times and always get the same behavior when run from the scripts in the group of nine.
Well, today 3-19-02, I decided to give it one last try. I deleted and recreated the related account dbf table. I had to also recreate the operations because they went with the dbf table. Guess what? The whole thing works without a problem!
BTY this is ver 4.5