Create Componente Dataset

elidorio2 · Post by **elidorio2** » 31.01.2007, 01:22

Your ZeosLib DBO Version: 6.6(beta)
The IDE you are using: Delphi
Version (and maybe patchlevel) of the IDE:
The database you are using: PostgreSQL
Version of the database: 8.2
Used protocol: tcp/ip
[hr]Error description and post

Hello Administrator of the Component Zeos!

I would like that when it goes possivél to create a component to be only a Dataset and that in him already comes the options of Insert,Delete and Update so that we didn't need to use more the component UpdateSQL. it Already exists like this in the component IBX and MDO.
Greetings;

Edson Lidorio
elidorio@yahoo.com.br

btrewern · Post by **btrewern** » 31.01.2007, 13:27

ZUpdateSQL only needs to be used when you are querying from more than one table in your database. Otherwise just use a ZQuery which should work in most cases.

Regards,

Ben

elidorio2 · Post by **elidorio2** » 31.01.2007, 13:35

Only that ZQuery doesn't have the object UpdateSql to be used when we needed to do insert,update and delete.

btrewern · Post by **btrewern** » 31.01.2007, 17:37

What is gained by using one component instead of 2? Or is there something I'm not understanding.

Regards,

Ben

elidorio2 · Post by **elidorio2** » 31.01.2007, 19:51

Ok Everything well!
The earnings and in easiness to work less growth in the datamodule,em time of 2 components the less for the system that uses 300 objects query.

elidorio2 · Post by **elidorio2** » 23.02.2008, 04:18

Now I understand!
So I use only p Zquery it automatically generates all necessary comados to Insert / update and delete? Do you use this?

--
Edson

Post by **mdaems** » 23.02.2008, 14:33

Of course. That's what it is all about!

TZUpdateSQL should only be used for joins, calculated fields, the difficult stuff.

Mark

elidorio2 · Post by **elidorio2** » 23.02.2008, 15:54

We had not understood at the time!!
These days now I developed a system with cds and used ZQuery + TUpdateSQL! There is a problem using this dual? I used because I did not know!!

--
Edson