Board index » delphi » Pros and Cons of using live queries

Nick Tentomas

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Pros and Cons of using live queries

Hi all,

I was wondering if any of you know of any significant pros and cons of
using live queries.  I can only think about pros ( be able to update the
data with using tables ) but I would like to know into what I am getting
into before I start using this feature.
I have Delphi 5.00 Enterprise with update Pack 1 installed and BDE 5.11.

Thanks in advance,

Nick Tentomas

 
Michael

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Pros and Cons of using live queries


If you don't want your users to be able to update records then your pro
becomes a con...

Quote
"Nick Tentomas" <Ntent...@CSBFACMGT.CSBFM.DAL.CA> wrote in message

news:39DB38D3.6D6F0284@CSBFACMGT.CSBFM.DAL.CA...
Quote
> Hi all,

> I was wondering if any of you know of any significant pros and cons of
> using live queries.  I can only think about pros ( be able to update the
> data with using tables ) but I would like to know into what I am getting
> into before I start using this feature.

> I have Delphi 5.00 Enterprise with update Pack 1 installed and BDE 5.11.

> Thanks in advance,

> Nick Tentomas

Pascal Batzli Junio

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Pros and Cons of using live queries


Personally, I prefer not to use it. One of the drawbacks is that it consumes
a lot more memory, since you are requesting live data, instead of just a
copy of the data. Depending of the amount of people that are conected, and
the size of your server, it could be a problem. I prefer to use an UPDATE
when the user presses the Ok.
Quote
"Nick Tentomas" <Ntent...@CSBFACMGT.CSBFM.DAL.CA> wrote in message

news:39DB38D3.6D6F0284@CSBFACMGT.CSBFM.DAL.CA...
Quote
> Hi all,

> I was wondering if any of you know of any significant pros and cons of
> using live queries.  I can only think about pros ( be able to update the
> data with using tables ) but I would like to know into what I am getting
> into before I start using this feature.

> I have Delphi 5.00 Enterprise with update Pack 1 installed and BDE 5.11.

> Thanks in advance,

> Nick Tentomas

Dell Stinnet

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Pros and Cons of using live queries


Another con is that you have to be VERY CAREFUL how you set up your SQL in
Delphi - the BDE will modify your SQL before sending it to the server.
Basically, it puts quotes around the field names making the field names
themselves case sensitive with most servers.  Thus if you do:

Select Field1, Field2
from MyTable

the BDE converts it to

Select "Field1", "Field2"
from MyTable.

If the actual field names are FIELD1 and FIELD2, you'll get an error when
you try to run your query because the case doesn't match.

-Dell

Quote
"Nick Tentomas" <Ntent...@CSBFACMGT.CSBFM.DAL.CA> wrote in message

news:39DB38D3.6D6F0284@CSBFACMGT.CSBFM.DAL.CA...
Quote
> Hi all,

> I was wondering if any of you know of any significant pros and cons of
> using live queries.  I can only think about pros ( be able to update the
> data with using tables ) but I would like to know into what I am getting
> into before I start using this feature.

> I have Delphi 5.00 Enterprise with update Pack 1 installed and BDE 5.11.

> Thanks in advance,

> Nick Tentomas

Nick Tentoma

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Pros and Cons of using live queries


Hi all,

Thank you for your answers. I do not personnaly like to use live queries but
their so tempting if you compare  them with manually setting up the various
events in order to synchronize edit text and memo fields with the database.

Regards,

Nick

Quote
Nick Tentomas wrote:
> Hi all,

> I was wondering if any of you know of any significant pros and cons of
> using live queries.  I can only think about pros ( be able to update the
> data with using tables ) but I would like to know into what I am getting
> into before I start using this feature.

> I have Delphi 5.00 Enterprise with update Pack 1 installed and BDE 5.11.

> Thanks in advance,

> Nick Tentomas

Other Threads

1. MS Access Pros and Cons of using VB vs DELPHI

2. Errors using Live Queries using DATETIME on Informix 7.3

3. Pascal Pros/Cons Vs. C, C++, Java

4. Replacement for BP7 - pros & cons needed

5. Labels .. Pros and Cons

6. PRO'S AND CONS OF INTERBASE ???

7. Database Components utilisation pros & cons

8. Database Components utilisation pros & cons

9. Report Components Pros/Cons

10. Table-type pros and cons