Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger -> Wrong Results
Message
De
14/02/2004 09:59:43
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00877268
Message ID:
00877385
Vues:
8
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform