Today's Topics: 1. BDE usage / replacement (Stephen Bowker) 2. Re: BDE usage / replacement (Sid Gudes)
---------------------------------------------------------------------- Steve Wrote >Hi, >I have been given a project to look at dropping the BDE from our >main application and using other means instead. >We have Firebird as our database, and the majority (approx. 90%) of >the units mainly use TIBQuery components for data access, but there >are some old units which still use the BDE, and we also create >temporary Paradox tables in some old units as well, so these use the BDE. > >The main question here is : "Is there any quick and easy way to >generate a list of units that are affected by / use the BDE ? >We have approx. 1400 pascal units in the main application, and would >ideally like a checklist as follows: >1. Global Search | Find in files for "TTable" - if exists, then >this unit needs to be changed. >2. global search for ...... etc etc. > >Has anyone else gone through this exercise, or know of any good >resources out there for this, as I don't know a great deal about the >BDE, not having used it before in any previous projects. >BTW - I'm using Delphi V5 & Firebird V1.5 > >Regards, >Steve Bowker **************************************** Hi Steve, we did do something like this. You should be able to use a simple 'find in files' to find all filenames that use TTable TQuery etc. That wasn't the difficult bit, from what I remember, the more tricky part was to reproduce the BDE functionality. The BDE is a nifty piece of software in that it caches records for you allowing you to scroll backwards and forwards through a list of thousands of records displayed in a grid without putting too much strain on the local computer's memory. It does this by maintaining its own buffer, going back and forth to the database only when necessary. Unless you are replacing it with something similar, you will have to do all this yourself. You could well end up with a new interface looking similar to the way browsers display lists of records with "Next" and "Prior" buttons. Regards Chris _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
