Search found 193 matches

by btrewern
20.02.2007, 09:50
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Update Failed On Complex Query
Replies: 9
Views: 2551

I think you could have two TZQuery components and work like that. You'd need to use transactions to keep your updates consistent but I suppose it would work.

Regards,

Ben
by btrewern
14.02.2007, 09:53
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Install of newest ZeosLib for Delphi 7 is not working.
Replies: 8
Views: 3216

Have you got an old version of Zeos around?

Regards,

Ben
by btrewern
13.02.2007, 17:02
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem using non-autocommit mode
Replies: 8
Views: 6089

I've never understood why Zeos does transactions the way it does. Currently I have to call BEGIN, COMMIT & ROLLBACK manually using SQL calls.

How does dbExpress or the BDE deal with this?

Regards,

Ben
by btrewern
13.02.2007, 16:12
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: [zeos newbie] Compiltation time
Replies: 2
Views: 615

Also try FastMM4. See the FastMM4BCB.cpp file for details.

Regards,

Ben
by btrewern
05.02.2007, 16:16
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7401

Could this be added to a README or INSTALL file somewhere?

Regards,

Ben
by btrewern
05.02.2007, 10:36
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: HowTo Installation ZEOSDBO 6.6.0 beta
Replies: 11
Views: 5404

In Delphi I do the following: 1. Add the src\core, src\component, src\dbc, src\parsesql and src\plain folders to Library path. 2. Open the ZeosDbo.bpg file in packages\delphiX folder. 3. Right click on ComponentDesignXX.bpl and then click Build. 4. Right click on ComponentDesignXX.bpl and then click...
by btrewern
05.02.2007, 10:12
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7401

If you use the PostgreSQL-7 protocol in Zeos then you just need the libpq74.dll from the lib folder in the Zeos distribution. If you use the PostgreSQL-8 protocol you will need the following files: libpq.dll (or libpq81.dll from zeos lib folder) comerr32.dll iconv.dll krb5_32.dll libeay32.dll libico...
by btrewern
31.01.2007, 17:43
Forum: MySQL
Topic: Zeos with Turbo Delphi Explorer
Replies: 2
Views: 1557

Try the ZDataset unit.

Regards,

Ben
by btrewern
31.01.2007, 17:37
Forum: Feature Requests
Topic: Create Componente Dataset
Replies: 7
Views: 3620

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

Regards,

Ben
by btrewern
31.01.2007, 13:27
Forum: Feature Requests
Topic: Create Componente Dataset
Replies: 7
Views: 3620

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
by btrewern
26.01.2007, 09:53
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Post Record & Insert new
Replies: 3
Views: 692

Do you have AutoCommit in your TZConnection set to false or maybe CachedUpdates on one of you datasets set to true?

Regards,

Ben
by btrewern
24.01.2007, 11:16
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to use ZUpdateSQL
Replies: 1
Views: 901

See the documentation for the BDE TUpdateSQL. The TZUpdateSQL works similarly.

Ben
by btrewern
17.01.2007, 10:51
Forum: 6.1.5
Topic: Zeos 6.15 and Oracle 9.2?
Replies: 14
Views: 6223

I don't use Oracle but when I need to find dependencies for a dll / exe I use Dependency Walker.

See here: http://dependencywalker.com/ for a free download

Regards,

Ben
by btrewern
16.01.2007, 10:57
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Where can I get detailed instructions on Zeos components?
Replies: 8
Views: 5931

Could a link to this be put into the Downloads section?

Regards,

Ben
by btrewern
10.01.2007, 10:15
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Need help with SQLProcessor
Replies: 10
Views: 2596

Just use a TZQuery as:

Code: Select all

With ZQuery1 do
begin
  SQL.Text := 'update tbl_test set nazwa=now() where number=1';
  ExecSQL;
end;
Regards,

Ben