>My 2 cents worth...
>I HATE arrays now after trying to maintain someone elses code. They used 279
>arrays that are PUBLIC. Every table, index, cursor & control is stored in an array. Even some of the array names are stored in other arrays. It's a horror to maintain. There must have been this style posted somewhere on the net 'cause I've seen this 3 times in different applications.
>
>I prefer cursors unless the ONLY solution is an array.
There are times when using a cursor is better, and times when using an array is better. You should not reject arrays just because somebody used them incorrectly.
In the system you mentioned, most public arrays and public variables can probably be replaced with private or local arrays or variables. The few that remain can be converted to properties of one, or a few, objects.
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)