Create Componente Dataset

Freature requests from users for ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist, mdaems

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Create Componente Dataset

Postby 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
Expert Boarder
Expert Boarder
Posts: 193
Joined: 06.10.2005, 18:51

Postby 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
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby 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
Expert Boarder
Expert Boarder
Posts: 193
Joined: 06.10.2005, 18:51

Postby 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
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby 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
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Create Componente Dataset

Postby 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

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby 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
Image

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby 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


Return to “Feature Requests”

Who is online

Users browsing this forum: No registered users and 1 guest