 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Hubert Rétif
Guest
|
 Posted: Tue Oct 24, 2006 7:06 pm Post subject: DAC for Firebird + some specific questions |
 |
|
Hi,
I have decided to replace my current MySQL DB with Firebird. Until now, I
have mostly worked with TADOQuery and the ODBC driver of MySQL. Just for
some specific queries (couldn't bring it to work with ADO) I have used DAC
from MicroOlap:
SELECT
count(*) as nbCar,
sum(sold_price) as CA,
(sum(sold_price)-sum(bought_price)) as BE,
round(
(sum(sold_price)/
(select sum(sold_price) from car_archive))*100,1) as CA_pcent,
round(
((sum(sold_price)-sum(bought_price)) /
(
(select sum(sold_price) from car_archive)-
(select sum(bought_price) from car_archive)
)
)*100,1) as BE_pcent,
reason_text
FROM car_archive
group by reason_text
order by CA_pcent desc
select
concat(
substring(cast(output_date as binary),1,4),
substring(cast(output_date as binary),6,2)
) as period,
(sum(sold_price)-sum(bought_price)) as BE,
(avg(days_elapsed)) as AV
from car_archive
where reason_text like '%Internet%'
group by period
order by period
My intention is to keep as far as possible the TADO components of Delphi
(7). Does anyone know whether I should expect some difficulties in this area
(also Inserts, Updates with TADOTable)?
If yes could you recommend a good and reliable DAC for Firebird which could
help?
Thanks,
Hubert Retif. |
|
| Back to top |
|
 |
Guillem
Guest
|
| Posted: Wed Oct 25, 2006 8:11 am Post subject: Re: DAC for Firebird + some specific questions |
|
|
Hubert Ritif wrote:
| Quote: | Hi,
I have decided to replace my current MySQL DB with Firebird. Until
now, I have mostly worked with TADOQuery and the ODBC driver of
MySQL. Just for some specific queries (couldn't bring it to work with
ADO) I have used DAC from MicroOlap:
snip
My intention is to keep as far as possible the TADO components of
Delphi (7). Does anyone know whether I should expect some
difficulties in this area (also Inserts, Updates with TADOTable)?
|
it's better to skip TADOTable when working with RDBMS like Firebird or
MySQL. It's a component designed to use with desktop dbs, which has the
(IMHO nasty) behaviour of trying always to load the whole table. Use
TADODataset or TADOQuery instead.
Said this, you should be able to use ADO with Firebird through ODBC.
The Firebird community provides an ODBC driver at its website.
| Quote: |
If yes could you recommend a good and reliable DAC for Firebird which
could help?
|
From the top of my head Zeos, FibPlus and IBObjects. IBX can *still* be
used but it's not a good idea since Interbase and Firebird surely will
follow different paths and compatibility issues will arise sooner or
later.
--
Best regards :)
Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
