I have a form that a bell rings when you run it. We put a debug in the Activate script. Don't know what prog. "n" is. This form works OK except for the bell going off when you frist run the form. Need help learning to trace down problems such as this.
Go to Tools, Advanced, System Monitor. Now launch your form. The system monitor will record where the problem lies.
World Leaders in all things RevSoft
We did like you said. We already knew that the bell is coming from the message
SYS 1000: Error Loading Program "N".
We need to know what/where and how we are calling program N. We have checked all the quick events and coding in the scripts of this particular form and have found nothing out of the ordinary.
What is the value of N? Have you tried starting the Engine Log and seeing what happens there?
World Leaders in all things RevSoft
The table looks like this in table builder…
KEY NOT NULLKEY 1 EST_JOB_NUMBER Y Y
KEY 2 FY Y Y
1 EST_JOB_NAME N YALL THREE FIELDS AER VARACHAR AND NOTHING IN THE DEFAULT.
THE ENTRY FORM WAS BUILT BY JUST SELECTING NEW FORM, CLICKING ON THE TABLE NAME, AND THEN SELECTING THE THREE FIELDS AND CLICKING OK. I CREATED A SECOND FORM THE SAME WAY AND STILL GET THE SAME ERROR LOADING IT. NO SCRIPTS OR CODING USED AT ALL ON ANY OF THE CONTROLS.
A Becker indicates that you know the name of the program that will not load and generates the error. Can you post it?
World Leaders in all things RevSoft
OH Well! I recreated the table then the entry screen. All is well now. It must have been something in the table building. The table only had 1 data field and a two part Key. I know you must have at least one character of data to create a record. I put an "N" in the column for not null. I think that may have been wrong because with only one field in the table, it can't be null. I'm guessing that even after I changed it to "Y", the system still would'nt work right.
I'm still a little confused butt, I always have been.