Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to detect if a field is used in a remote view
Message
De
07/05/2005 05:56:30
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
06/05/2005 21:04:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01010684
Message ID:
01011888
Vues:
17
>Hi Cetin,
>
>Thanks again for the reply.
>
>I tried what you suggested and it works. There is a slight problem though.
>The remote view was created but the update properties were not set.
>
>Did I miss something?
>
>Thanks in advance...

Mike,
That single command doesn't update view properties like keyfiledlist,updatenames etc. First get your original dbc's programmatic version using gendbc. Then it'd be easier for you to find the places in code for changes. Edit code and run (only views if your prefer with a "drop view..." followed by "create sql view...."). It'd create your views afresh.
If you only edit and run sections for views your data would stay put. Views are just definitions. However after running it don't forget to pack your dbc or it'd get fatter.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform