>>>>I´m converting an old clipper aplication for
>>>>one customer to vfp6.0 with sp3.
>>>>
>>>>One database, which has the data of all the students since
>>>>1995 works just fine in clipper, i can access all the records,
>>>>but when I´m inside of the aplication foxpro just cant see
>>>>the records. What´s wrong?
>>>
>>>Is it possible there are more than 255 fields in this table? That is something that Clipper allows which Fox doesn't.
>>
>>Hello Mark!
>>Is this limitation a major concern in database development? I think so but others may argue...
>>
>>Jess
>
>I have never even approached 100 fields in a single table. I would argue that if you think you need that many fields, the design needs to be looked at really hard. IMHO, a table approaching that many fields could indicate a poorly normalized table.

Ok, your argument is highly regarded. How about using many filtered indexes in a single table? I have that concern in mind because we are about to develop a Hospital System that we think we have to use huge filtered indexes. We primarily choosing this approach because it's much faster than set filter, views etc.