I've had this problem maybe a year ago, but it stopped happening after we switched over to XP from 98. Now it happened again and I'm stumped.
Here's the situation. Two files are openned exclusively, table1 and table2. I add records to table1 and then call APPEND FROM table1 when I'm in table2's workarea. Then I do some more stuff with table1 and then ZAP it. Table1 is my temp table and table2 is the permanent one.
The problem is that sometimes the APPEND FROM command doesn't seem to do anything. No error is given, yet no records are copied.
You can see that this would be a pain. The APPEND FROM line is basically skipped and then I do my printing of labels and reports with the temp table and then ZAP it, thinking the data was appended to the permanent file.
I know no error is given because I have no special error handling (ON ERROR) and no error message comes up (so the operators say).
Has anyone ever heard of this?
[update]
To fix the data, I manually created a new record in the permanent table and filled in some basic information. Then an operator went into the appropriate form to fill in the rest of the fields.
Since I had entered a field with an invalid number, the program crashed when she tried to change it (because it was looking in another table for a non-existing record). Yes, I know. I'll get arround to error handling soon so it doesn't just make you exit.
BUT, once the application was started up again, she said that all the fields had all been filled in! She said she definately did not enter any new information except for trying to change that one eroneous field.
What's up with that? Was the APPEND FROM command somehow buffered and done at a later time? I can't imagine this happening since both table were openned exclusively.
[/update]
Here's the situation. Two files are openned exclusively, table1 and table2. I add records to table1 and then call APPEND FROM table1 when I'm in table2's workarea. Then I do some more stuff with table1 and then ZAP it. Table1 is my temp table and table2 is the permanent one.
The problem is that sometimes the APPEND FROM command doesn't seem to do anything. No error is given, yet no records are copied.
You can see that this would be a pain. The APPEND FROM line is basically skipped and then I do my printing of labels and reports with the temp table and then ZAP it, thinking the data was appended to the permanent file.
I know no error is given because I have no special error handling (ON ERROR) and no error message comes up (so the operators say).
Has anyone ever heard of this?
[update]
To fix the data, I manually created a new record in the permanent table and filled in some basic information. Then an operator went into the appropriate form to fill in the rest of the fields.
Since I had entered a field with an invalid number, the program crashed when she tried to change it (because it was looking in another table for a non-existing record). Yes, I know. I'll get arround to error handling soon so it doesn't just make you exit.
BUT, once the application was started up again, she said that all the fields had all been filled in! She said she definately did not enter any new information except for trying to change that one eroneous field.
What's up with that? Was the APPEND FROM command somehow buffered and done at a later time? I can't imagine this happening since both table were openned exclusively.
[/update]
