Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Synchronizing data
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00416319
Message ID:
00417267
Vues:
21
Hi Willie,

I see you got a credit from Doug Hennig for his remote app update article, good job.

Regarding the last update question, yes we do this with stored procedures. What you can do is in the table's "RECORD VALIDATION RULE" call a function stored in the DBC procedures which will update the appropriate field in the record. Also in the default value for that field place the same call.

Glenn


>Hi to all
>Before I reinvent the wheel I thought I’ll ask a friend(s).
>
>I need to synchronize the data of to tables with the same names, belonging to the same DBC.
>
>Every time a record is changed a field (lastupd) must be updated automatically. The easies way I think of doing it is to change it when you save a record. The problem with that is that one have about 30 input forms, it can be a lot of work with a lot of debugging.
>
>The other alternative is to use the dbc’s stored procedures.
>
>Has anybody done something like this before in a class. If I do it in the stored procedures, it will be replaced every time I rerun RI update.
>
>Thanks
>Willie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform