Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disable Trigger??
Message
From
28/05/1998 06:11:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
28/05/1998 05:48:54
Thongchai Prertpornpan
Grolier International, Inc.
Bangkok, Thailand
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00102650
Message ID:
00102655
Views:
27
>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
>
>Thanks,
>Thongchai
In trigger add :
if type("lManual")="L" and lManual
return .t.
endif
*Then before calling append 
lManual = .t.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform