Has anyone experienced any problems with the APPEND operation?
I am using ALPHA5 Vers. 4.03
On many occasions I had the append operation change information on my records, such as taking the account number from one customer and putting it on the record of another.
I tried to have the records that violate field rules marked, it noted that so many records were marked, but when I looked for the marked records there were none. I ran the same operation quite a few times and I always got the same results.
I tried appending from a table with field rules to another without rules and I experienced problems. I did the reverse, appending from one without field rules to one with rules and I also had problems.
I reevaluated the field rules for violating records and no violating records showed up.
If I append from a table without field rules to another without, than the append works correct.
I had the same experience on prior occasions, but I do not remember how many records got mixed-up. This time from what I could see, there were 10 records out of 1842.
In the field rules, under validation, I have marked that a specific value must exist in another table, but the values all exists.
I have tried and tried, and not been able to find the cause.
Thanks
Robert
I am using ALPHA5 Vers. 4.03
On many occasions I had the append operation change information on my records, such as taking the account number from one customer and putting it on the record of another.
I tried to have the records that violate field rules marked, it noted that so many records were marked, but when I looked for the marked records there were none. I ran the same operation quite a few times and I always got the same results.
I tried appending from a table with field rules to another without rules and I experienced problems. I did the reverse, appending from one without field rules to one with rules and I also had problems.
I reevaluated the field rules for violating records and no violating records showed up.
If I append from a table without field rules to another without, than the append works correct.
I had the same experience on prior occasions, but I do not remember how many records got mixed-up. This time from what I could see, there were 10 records out of 1842.
In the field rules, under validation, I have marked that a specific value must exist in another table, but the values all exists.
I have tried and tried, and not been able to find the cause.
Thanks
Robert
Comment