Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to index a tmp file ?
Message
From
23/01/2002 06:39:32
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
22/01/2002 22:45:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00606566
Message ID:
00608855
Views:
20
>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)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform