Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid-insert blank before
Message
From
16/01/2007 08:11:17
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01185817
Message ID:
01185851
Views:
7
>>>Tore,
>>>Tables have only few thousands of records. Once put in order there will be no changes for
>>>given parent-child couple. Only cascade deleting and updating existing values in records.
>>>
>>>This form will be used in initial phase of table populating and natural order is important.
>>>I don't need and dont' want use indexes. So, any suggestion ... ?
>>>
>>>Thank you.
>>>gojko
>>
>>If you don't want to take an advice from a programmer who have used VFP for nearly 20 years, I usually won't help. Anyway, if this is necessary to create an initial table, here are my advices
>>1. Use an index. No argument, just do it!!!!!!!!!!
>>2. When you are done entering the initial data, copy the data to NEW table which you use in production.
>
>Ooooooh! I love it when you're so forceful, you big old Viking you :-)

Wwwrrrrooooaaaarrrrr!

>>
>>NB! Relying on the natural order of a table is TERRIBLE design, which will give you big problems if you later must upgrade to for instance SQL server where there is no natural order. Heck, what are indexes for? Once you create an index tag, it will make your table appear to be the order you want, FOREVER! VFP has "automatic gear", why don't you want to use it?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform