I have an application using BDE and Paradox tables that has overwhelmed the capabilities of BDE and/or Paradox -- too many records -- in Delphi 7. Translation: a file gets corrupted after adding a few 100,000 records. Every time.
I really have no desire to totally rewrite all the database access routines (there are dozens and dozens). What is the least painful alternative database type to use? I am familiar with SQL from web site applications, but not in Delphi. All the file structures are static -- no adding or removing fields or indexes during execution. The programs are written for a single user -- no locking worries. In BDE terms, I tend to use IndexName, Active, FindKey, FindNearest, Next, Prev, First, Last, Eoi, Edit, Insert, Append, Post, Delete, the "magic" type-converting field variables; DBGrid, DBNavigate, OnPost, and not much else. Suggestions will be much appreciated -- especially those that confine most code revisions to the Data Module or other central location. Thanks, Rainer _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
