Seema --

Just taking a stab here. Is Computer Associates' Visual Objects -- the Windows OO successor to Clipper -- a viable option? I heard that the initial 5.o release was really buggy, but tamed in later minor releases. Also, for your purposes, backwards compatibility in code would seem a requirement, and I'm not sure if that's the case.

Jay

P.S. Haven't heard any word about the max number of fields being changed. AFAIK that would further change the DBF structure in and of itself, and would make all tables in the new format automatically incompatible with any SW accessing DBF style tables.





>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! Our old DOS clipper program has been running without a hitch for the last 12 years, hence we don't want to reinvent the wheel if possible. I hope you understand.
>
>The reason to migrate to VFP is our old program is DOS based and sooner or later we will have to convert to windows. Unfortunately good old DOS days are gone. People would like to have that windows look. 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!
>
>Waiting for that bright idea which would not require us to make major changes in the old code. That is probably asking too much. Does anyone know if ver 7.0 will allow more than 255 fields?