Page 1 of 1

Create Componente Dataset

Posted: 31.01.2007, 01:22
by elidorio2
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

Posted: 31.01.2007, 13:27
by btrewern
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

Posted: 31.01.2007, 13:35
by elidorio2
Only that ZQuery doesn't have the object UpdateSql to be used when we needed to do insert,update and delete.

Posted: 31.01.2007, 17:37
by btrewern
What is gained by using one component instead of 2? Or is there something I'm not understanding.

Regards,

Ben

Posted: 31.01.2007, 19:51
by elidorio2
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.

Create Componente Dataset

Posted: 23.02.2008, 04:18
by elidorio2
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

Posted: 23.02.2008, 14:33
by mdaems
Of course. That's what it is all about!

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

Mark

Posted: 23.02.2008, 15:54
by elidorio2
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