>HI all,
>
> I have 2 databases, let's say A and B. Both are the same. Then I change structure of some
>tables in database B and want to copy data from database A. How can I do?
>
> I zap all tables in database B and APPEND FROM all tables in database A. This should be work
>but there is a problem.
>
> My database have trigger and when i APPEND data from another database, VFP will check
>the trigger and ...trigger failed :<
>
> In my opinion, if the trigger is disabled while appending data, this problem won't occur.
>But how to do this. Does anyone know? Or have any opinion? Please tell me
Thongchai,
In order to clearly understand your message please try use the right terms in VFP world.
DATABASE refers to DBC
TABLES refers to DBF which is inside the DBC.
DATA refers to records in the table and not in the DBC.
Are you saying you have two tables: A and B with the same structure. You tried to modify the structure of A then copy the data from B using APPEND FROM?? If so, then there should be no problem as long as there is no violation on the triggers. What is the trigger error? Can you post it here in UT.
>
>Thanks,
>Thongchai
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."