Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Firing a vfp trigger froma sql trigger
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Firing a vfp trigger froma sql trigger
Divers
Thread ID:
00943476
Message ID:
00943476
Vues:
89
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform