>>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