Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to index a tmp file ?
Message
De
23/01/2002 06:39:32
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
22/01/2002 22:45:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00606566
Message ID:
00608855
Vues:
17
>Hilmar,
>
>>I recommend you start using database tables. You miss a lot if you don't.
>
>I think in database tables we should setting up the usage of tables in all program we'll
>make 'Cause we could not use one of the table within the database tables anymore for
>another program.
>Database tables using compound index, is it more saver than free table since one compound
>index for one table although it can consist of many structural index (tag index)
>
>Could you tell me the advantages of using database tables rather than using free tables ?

One important disadvantage, of course, is the lack of compatibility you mention. If you need to access your data from old FoxPro, you may need to continue using free tables.

Some of the things you can only do with tables in a DB:
  • Long field names (break the 10-byte limit).
  • Transactions
  • Referential integrity
  • Triggers (referential integrity uses triggers)
  • Field-level validation, and record-level validation (I don't use this, and prefer to use triggers instead)

    HTH, Hilmar.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Précédent
    Suivant
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform