Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Key fields: alpha vs. numeric
Message
 
 
To
15/01/2000 15:35:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00318449
Message ID:
00318670
Views:
26
>>>To digress just a bit, I have always had a philosophical hang up with using numeric type fields for essentially non-numeric data?
>>
>>(Just from experience) That is a good philosophy, character fields are faster than numerics. I think Integer is faster than them both though, and thats what you shuld use as your PKs or FKs.
>
>Gracias to you and Andrew. It still bugs me though. :)

Once you start [if not already] using parameterized views [local and/or remote], you will be mighty grateful that you use meaningless, integer key fields.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform