Hello Seema.

I knew I had that question coming. 1000 fields does seem absurd, but unfortunately that is how the original program was designed. The databases grow dynamically not only record wise but field wise also! Yeah you read it right - field wise too!

In that case, saying that the program was "designed" seems to me to be an Oxymoron < g >. JMHO.

Our old DOS clipper program has been running without a hitch for the last 12 years,

I say leave it alone then. DO not even bother to migrate to VFP.

So the only code that needs changing is the user interface (screens) in our old code. All our database commands and functions work as is in VFP except for this major problem we have with the limitation of fields!

Seems like a lot of work for no added benefit. Just prettier screens and no new functionality.