Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refresh function
Message
De
16/07/2021 18:15:39
Thomas Ganss (En ligne)
Main Trend
Frankfurt, Allemagne
 
 
À
16/07/2021 17:18:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01681815
Message ID:
01681825
Vues:
26
The Thor way (who needs fine tools if you have Mjölnir) of doing this is to double each field in your view and update doubled field with table value if changed. More elegant would be a second cursor of changed records linked via set relation plus a function returning changed field names or empty string...

>But I am looking to show them changes made in the underlying table. If I really really did not want to move the record pointer in the table (I am thinking now), I would have to a) run a new query of the same records against the table to get the values from the table again and then b) run a query against the view to get the current values there (using the phrase "WITH (BUFFERING = .T.)" to get the latest changes to the view
>
>and then compare them; this allows me to not move the record pointer in the view/grid.
>
>If I *did* detect the change, the code would still have to find the records with differences in the grid and set some flag on the view there that could then be used to show that the view is out of date with the table (for changes made by another).
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform