I am puzzled and hope someone can explain what is happening. There are two computers that are working in the same database. My computer has a Pentium 4 2.4GHz processor with 1 GB Ram. The other has a Celeron processor 1.8GHz with 1 GB RAM.
This is a fairly complex database with a number of tables, forms with many calculated fields, and quite a few scripts.
Everything works fine except one series of scripts that are activated by a button on a form. These scripts parse a memo field (of any size) into 150 character entries which it enters into a field in a different form. When finished with the last entry it pops up a dialog box asking whether you want to update a date on yet a different form. The scripts are controlled by conditional expressions. The variables in those conditional expressions are initially set by field rule and form events, and some are changed within the running of the scripts.
When the scripts are programmed from my computer (Pentium) they work correctly on my computer, but generate error boxes on the other (Celeron) computer that give the name of a variable, the equation, and state "Too many parameters."
When I go the the other (Celeron) computer, delete the variable definition, and all changes to it in scripts, then reenter the definitions and changes from that computer it works perfectly on that computer, but causes my computer to generate the popup dialog box with every 150-character entry (rather than when the parsing is completed) because the variables are not being properly set/reset.
Any suggestions would be appreciated.
Thanks.
Marilyn Wallace
This is a fairly complex database with a number of tables, forms with many calculated fields, and quite a few scripts.
Everything works fine except one series of scripts that are activated by a button on a form. These scripts parse a memo field (of any size) into 150 character entries which it enters into a field in a different form. When finished with the last entry it pops up a dialog box asking whether you want to update a date on yet a different form. The scripts are controlled by conditional expressions. The variables in those conditional expressions are initially set by field rule and form events, and some are changed within the running of the scripts.
When the scripts are programmed from my computer (Pentium) they work correctly on my computer, but generate error boxes on the other (Celeron) computer that give the name of a variable, the equation, and state "Too many parameters."
When I go the the other (Celeron) computer, delete the variable definition, and all changes to it in scripts, then reenter the definitions and changes from that computer it works perfectly on that computer, but causes my computer to generate the popup dialog box with every 150-character entry (rather than when the parsing is completed) because the variables are not being properly set/reset.
Any suggestions would be appreciated.
Thanks.
Marilyn Wallace
Comment