Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Call a .prg from a trigger ????
Message
 
À
26/08/2016 18:31:03
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01640061
Message ID:
01640066
Vues:
50
>>I haven't really messed with triggers in VFP tables - and wondering if it's possible to do this.
>>
>>I want to run a .prg from a trigger. Basically what I'm trying to do here is when a record in a table is appended or updated, I want it to also update a remote view. I'd like to so this from the table itself so I don't have to change a huge pile of code. Is this even possible???
>
>Something about export/import procedures or some such... there's a bunch of stuff in the database itself... Don't have fox at the moment (could visit the server, though, but not sure whether I have any dbc there) because I don't even have windows on this box (long story... and yesterday was the last day when Microsoft owned this box... from now on, it gets its own cage, virtual, and stays there). But IIRC you can have a routine with just about any name inside the dbc's code, and call that from triggers. So maybe not a separate prg but a procedure inside the dbc.
>
>Boy it's been years... I think last time I had to intervene in a dbc was four or five years ago, and those were some stragglers.

Yep - creating a stored procedure in the DBC right now - which I can call from the trigger. I think I can get this all to work :)
ICQ 10556 (ya), 254117
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform