Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call a .prg from a trigger ????
Message
From
26/08/2016 18:31:03
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01640061
Message ID:
01640065
Views:
67
>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform