itn.zipITN Calc Update Samp.txt
While Testing this set and scripts I have experienced some unusual errors that seem to come from out of the blue.
I have heard the saying -" work on Sunday, Break down on Monday,"
but in my case I worked and broke down on Sunday.
I thought everything was working with stability over the past 2 days.
After review of calculations made in Calculated fields in ITN.dbf, I revised some of the field rules using the Genie.
I made the changes in ITN.set. I had some problems saving the changes but was able to correct any problems and save.
I tried to recalc. field rules but the recalc command will not execute. It shows a progress bar at 0% and won't move.
I used the exit command, exited A5 and then rebooted.
I opened and checked the field rules in ITN.set and ITN.dbf but found no problems.
I tried running the attached script, but I get a line 45 error stating that the result cannot fit a N field of that size.
Further background - I did have to adjust a some field sizes on Friday night as data to be imported from1 record did not fit a specific field. I also made the correction in ITN where the data eventually would be stored as well. The program and scripts were still working fine 24 hours later. I tested all of the operations/routines in scripts last night and it worked fine.
I revised about 6 Field Rules last night and the attached script started generating the line 45 error. None of the fields in this script were changed.
Before I restore a back-up from yesterday and redo a few hours of work, does anyone have a suggestions on how to resolve this type of problem and what may be the cause?
Thanks
Bill W
While Testing this set and scripts I have experienced some unusual errors that seem to come from out of the blue.
I have heard the saying -" work on Sunday, Break down on Monday,"
but in my case I worked and broke down on Sunday.
I thought everything was working with stability over the past 2 days.
After review of calculations made in Calculated fields in ITN.dbf, I revised some of the field rules using the Genie.
I made the changes in ITN.set. I had some problems saving the changes but was able to correct any problems and save.
I tried to recalc. field rules but the recalc command will not execute. It shows a progress bar at 0% and won't move.
I used the exit command, exited A5 and then rebooted.
I opened and checked the field rules in ITN.set and ITN.dbf but found no problems.
I tried running the attached script, but I get a line 45 error stating that the result cannot fit a N field of that size.
Further background - I did have to adjust a some field sizes on Friday night as data to be imported from1 record did not fit a specific field. I also made the correction in ITN where the data eventually would be stored as well. The program and scripts were still working fine 24 hours later. I tested all of the operations/routines in scripts last night and it worked fine.
I revised about 6 Field Rules last night and the attached script started generating the line 45 error. None of the fields in this script were changed.
Before I restore a back-up from yesterday and redo a few hours of work, does anyone have a suggestions on how to resolve this type of problem and what may be the cause?
Thanks
Bill W
Comment