Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I free table from DBC at client end?
Message
 
 
À
18/04/2001 19:52:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00496798
Message ID:
00497082
Vues:
37
>Desperate times, desparate measures. Actually here in Canada, that's how we play hockey. (<bg>).
>
>Back to serious stuff - I have a command window built outside my app but accompanying it, so I did what you said by
>(1) opening dbc
>(2) remove table xxxx
>
>and that worked good. Then I opened the app so it could process the oSdtMeta.Update("ALL!ALL"). It worked sort of ok, but instead of reading the COREMETA for the free tables (VFXSYS in particular) and updating the user's copy of the VFXSYS table to match the COREMETA, it created a new VFXSYS in the Update directory. My client's VFXSYS table (located in the DATA directory) did not get the new fields and the empty VFXSYS file created in the Update directory was left in that directory, so the next time I ran the app, it updated the client's VFXSYS structure but lost all the data. (It seems it overwrote my clients file with the VFXSYS found in the Update directory (which it created).
>
>So, how do I prevent losing all my clients data in these free tables and still get the structures updated???

You do not provide the new, empty, tables to your customer. All you do is copy the new SDT tables and the 3 database files [DBC, DCX and DCT] into your customer's data folder. You also should open nothing in the Update folder. This is just a temporary location for the new SDT and database files. After they are copied to the production data folder, they should be deleted from the Update folder. Then just open the database and run the SDT Update method.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform