Re: BDE support??

"Eddie Shipman" <eddie.shipman@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:MPG.1e075d22f062187d98971d@xxxxxxxxxxxxxxxxxxxxx
> In article <MPG.1e03ce8c658a429698971c@xxxxxxxxxxxxxxxxxx>,
> eddie.shipman@xxxxxxxxxxxxxxxxxxxxxxxx says...
>> Do we know if, and when, Borland will discontinue support of BDE?
>> I need this for an argument to convert to ADO.
>>
>
> OK, let me expand on this somewhat...
>
> We have an application that is using controls descended from TDatabase,
> TQuery and TStoredProcedure. The controls access MS SQL Server2K and
> we'd like to convince the higher ups to ditch the BDE and move to ADO.
>
> We have no local files, Paradox, but the BDE creates those confounded
> LCK files regardless of what DB you are using.
>


>
> Our, the development team, intention is to convert the controls to ADO
> based controls and then write new development using ADO, then
> incrementally changing out the old BDE accessed stuff to use the new ADO
> controls.
Sounds good to me.

>
> Seems like a good plan but, of course, it'll taks some time. We just
> have to come up with some benefit to the customer as well as our
> company.
>
You have to find something that causes pain to the execs or that
the customers notice. Do the lock files mentioned above relate?

Create some tests and measure performance difference between the two.

Transactions?

You'll have an easier time of it than we did. Since you are using the
same database, you can replace the TQueries one at a time as you work
on different forms until you get it down to a small number and knock the
rest out.

At the same time that we did this, we were looking for a way to make
our apps easier to unit test. Cary Jensen suggested that we use
ClientDataSets.
That has worked very well for us.
In the actual app, we run against MS-SQL. In most of the tests, we run
against
XML files. We can set up multiple XML files to represent various result
sets.
Very nice for unit testing, without involving the DB.

I just mention it because if you do this, you'd want to do it at
the same time, and if they see unit testing increasing your reliability
and as valuable, then that might justifiy the change for you.

HTH,
Brad.


.

Relevant Pages

  • Re: BDE support??
    ... We have an application that is using controls descended from TDatabase, ... we'd like to convince the higher ups to ditch the BDE and move to ADO. ... Our, the development team, intention is to convert the controls to ADO ...
    (borland.public.delphi.non-technical)
  • D7 & ADO with ASA9: EOLEException & Multiple-step error
    ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
    (borland.public.delphi.database.ado)
  • Re: Conversion from BDE to ADO
    ... I've noticed no performance problems with ADO and MSSQL. ... conversion). ... > I am currently experimenting with converting a quite large app from BDE to ...
    (borland.public.delphi.database.ado)
  • ADO and BDE interact on XP SP2?
    ... It uses the BDE ... indirectly to connect to a database. ... also optionally uses ADO to connect directly to the database for ... but of course any built in initialisation will have taken place. ...
    (borland.public.delphi.database.ado)
  • Re: Enhancing ADO Performance
    ... > currently have applications constructed to retrieve data from ODBC ... > worked with both because of the installation issues when using the BDE ... It seems that ADO ... of data and hooking to a DB grid, use a server-side cursor. ...
    (borland.public.delphi.database.ado)