Having done some similar things that you are facing, let me give you some tips in looking for an alternative database:
1. Multi User or Single user? If your pkg is a single user application, look for free versions of single user Database. NexusDB is the next generation to the old Flashfiler database. They offer a free single user version IIRC. 2. Conversion programs. Most BDE alternatives have a conversion utility to convert Paradox tables to their format. 3. Support: Support comes in many ways; email, phone, chatrooms, etc. Sometimes the support is grudgingly given, so be sure to try it before you commit to it. Kyle Cordes has a website devoted to BDE alternatives: http://kylecordes.com/bag/ I have looked at and liked these three databases: NexusDB http://www.nexusdb.com/showpage.asp?index=97 Good program. Easy to convert. Expensive Advantage Database server http://www.advantagedatabase.com/web/content.aspx?key=79D35E8C44D23A8EA9 BB2E0A5A8536A2 Very fast. Client server version only. DBISAM http://www.elevatesoft.com/ Never used it but I hear it is the most "Paradox like". One final note: There are free databases such as Flashfiler which is open source but the support is poor and the learning curve can be steep. Good luck in your search! Tom Nesler -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rainer von Saleski Sent: Thursday, May 31, 2007 1:59 AM To: delphi-db@elists.org Subject: Paradox --> SQL in D7 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 _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
