Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger -> Wrong Results
Message
From
14/02/2004 09:59:43
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00877268
Message ID:
00877385
Views:
9
>Hi Gregory,
>
>Thank you so much for your answer! I study your code and It should work. But I have other problems here.
>I don't use to access the table directly, either buffers, etc.
>
>In my forms, I just want to fire one line -> Update Table_B Where BlaBlaBla Set Total_B = 100 and I want to VFP do the rest...
>But I think it is not possible... It is not possible this way.
>
>Thank you, once again!

hi Rodolfo,

It's possible with a trigger (I use a lot of them)

You can change the triggers in the table properties

eg
xx = dbgetprop('Table_B', 'Table', 'UpdateTrigger')
xx = xx + iif(empty(xx), '', ' and ') + 'Table_B_trigger("U")'
delete trigger on ('Table_B') for Update && may not be necessary
create trigger on ('Table_B') for update as &xx

&& similar for insert

&& similar for delete
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform