Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating SQL View
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updating SQL View
Divers
Thread ID:
00685149
Message ID:
00685149
Vues:
64
I have some tables I will use to create an SQL view.
Here are a couple of fields in the view:
view.BeginTime <- Table1.StartTime
view.EndTime <- Table1.StartTime + Table1.ElapsedTime

If the original table is to be updatable what do I need
so that Table1.ElapsedTime is updated correctly when
view.EndTime changes?

Thanks for your help.
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies ......... http://abri.com/
'Recover' - top rated FoxPro/dBase file repair utility.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform