Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Firing a vfp trigger froma sql trigger
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Firing a vfp trigger froma sql trigger
Miscellaneous
Thread ID:
00943476
Message ID:
00943476
Views:
88
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
.......
DO WHILE .T.
      ME.Work()
ENDDO
Next
Reply
Map
View

Click here to load this message in the networking platform