Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert before
Message
 
 
To
05/07/2006 13:05:42
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01133860
Message ID:
01133984
Views:
17
>Hi Mike,
>I want records reorederd in right table not only in grid and without indexes on tables and
>without field which connects rows; rows on right are grouped together for left row, then follows rows for second left row and so on ...
>Regards, Gojko

Hi Gojko,

Yes this can be done programmatically but if you don't use indexes, even hidden to the user it gets slower and slower every time when records added.

Another penalty is that if no "key" is used between records in table A and B, after even a small corruption you are mixed to the greatest mess ever. Every time you open, look or reorder table B, the situation is "static" and hard to repair after a possible corruption OR user error (yes those can happen in real world) but with a index/relation key (you can use even a third "hidden to user" table to relate tables A and B) the situation is "dynamic" and much less harm you will get.

AT
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform