Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Musing on treating causes and not symptoms
Message
From
27/10/2003 01:43:57
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
27/10/2003 00:50:11
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00842795
Message ID:
00842810
Views:
31
>Hm. I disagree. Tables that have blank rows (possible) aren't normalized. The solution is in data logic, IMO.

On second thought, if by "data logic" you mean implementing some kind of table constraint so blank records aren't allowed at the *table* level, I think this truly is the fundamental solution - rather than fixing a data entry form. After all, someone could go in later and (assuming it's VFP) use raw VFP or attach via OLEDB and mess around with records. Or Access or Excel, for that matter.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform