Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free tables vs DBC
Message
From
11/01/2003 12:57:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
11/01/2003 11:26:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00740632
Message ID:
00740644
Views:
26
>>>I am writing a small gradebook app that will be distributed widely and needs to be almost bomb proof. In this case, could free tables be a better choice than tables in a DBC since I don't need long names or stored procedures? What is the downside?
>>
>>You would also lose RI. I consider this part very important. Also, you can't have default values for fields - very useful for "auto-incremented" fields, for VFP versions older than 8.0.
>>
>
>Gracias Hilmar. The goal is to minimize tech support required since many users will be teachers out in the boonies. What else would I be giving up?
>
>Alex

I am not sure of the complete list; check the manuals. I don't have VFP at this machine. What comes to my mind now is:

  • Long field names.
  • Validation rules, for fields and records (I don't use these - I prefer triggers).
  • Referential integrity (RI).
  • Triggers. Important to update a second table with changes in a first. Triggers are used for RI.
  • Free tables can't participate in transactions.
  • Field comments - useful for documentation.

    There may be a few other options, but this is enough to use a database even for a relatively small system.

    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