>This could seem wierd but that is what I need to do,
>
>I need that everytime a record is inserted, updated or deleted in a sql table, a trigger would tell VFP what specific record was modified then vfp will delete a reference in a treeview in an active form which contains a monitor of the status of the records, they aren't in the same order or display as in the table off course.
>
>I don't know if this make any sence to you, any other way to to this would be greatly apreciated and reviewed.
>
>just to be more specific , this is the scenario
>
>an active form showing the records of a particular table in sql server, they are shown at a treeview
>there is an insert, delete, update at sql server
>this fires a trigger to tell the form, whixh record had been updated
>the form call a method with some particular id that sql gave it to delete, modify, or insert a new item at the treeview
There might be multiple ways to do that. Assuming you mean any delete,insert,update done from anywhere, you might write out a list of PK ids of those deleted,modified,inserted from triggers and a timer in your form checks that notifier.
Instead of writing out it might write to one of your notiifier tables and w/o a timer you can respond with dbc_events.
Cetin