Search found 278 matches

by gto
03.05.2006, 14:29
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Master/Detail Relationship
Replies: 3
Views: 1896

Hello tonydm ! The master/detail relation will work if you do that: [master query] ------ [data source] | | | [detail query] Understanding The master query you will setup normally, as you want, using filters, SQL or anything you like. After that, you will put a TDataSource (yes, that which comes wit...
by gto
28.04.2006, 12:56
Forum: Announcements
Topic: Reasons for being temporarily unavailable ...
Replies: 7
Views: 7442

woohoo :)
BTW, I think the posts here wouldn't affect much people, even that we don't talk in pilitics, oil, world domination and other "non-important stuff" :D
by gto
17.04.2006, 17:55
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Removing requestlive property after upgrading
Replies: 3
Views: 773

This is a new project or something that was created using other zeos version? If it's not new, try to look for RequestLive property into .dfm files, and remove the lines with it. If It's new, packages from old zeos versions (other delphi version or previous installation) may be around. You need to r...
by gto
31.03.2006, 13:30
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Firebird dll name
Replies: 5
Views: 1495

sandeep_c24 wrote:Does anyone know who is looking after Zeos and who the are Team members are. To me it looks like no one is really actively developing Zeos.

Sandeep
take a look :)
http://seegernet.koolhost.de/zeosforum/ ... .php?t=413
by gto
24.03.2006, 13:50
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Firebird dll name
Replies: 5
Views: 1495

That would be nice! A configurable property in ZConnection which handle the library name. Shall we post it to sourceforge, as a request?
by gto
24.03.2006, 13:48
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Firebird 1.5 and BLOB (as text)
Replies: 3
Views: 1582

Yeah! Works like a charm :thanks: I'm posting the procedure here, if someone want copy it: procedure TZParamsSQLDA.WriteBlob(const Index: Integer; Stream: TStream); var Buffer: PChar; BlobId: TISC_QUAD; BlobHandle: TISC_BLOB_HANDLE; StatusVector: TARRAY_ISC_STATUS; BlobSize, CurPos, SegLen: Integer;...
by gto
20.03.2006, 22:42
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Query.RowsAffected is always -1
Replies: 12
Views: 2799

hmm, I think btrewern mean the RecordCount property about the RowsAffected, testing here with firebird it's exactly what happens. into the deep of zeos, the RowsAffected property comes from an interface, reading the value of FRowsAffected which is set by: FRowsAffected := Statement.ExecuteUpdatePrep...
by gto
20.03.2006, 13:57
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Query.RowsAffected is always -1
Replies: 12
Views: 2799

Hello there

The RowsAffected property only have a value if you are inserting, deleting or updating rows. The select statement always resullts in -1 value.

By the way, I've only tested with ExecSQL method, hope the .open (and active := true) works too, but always with a non select statement.
by gto
18.03.2006, 13:40
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Cannot install in Delphi 7
Replies: 3
Views: 1003

BTW, if you want to know, the problem is that CVS from 13/10/2005 (the last one), in that file, has an ";" where it need to be a "," Just download, install, and when compiler reports the error, go one line up and to the end of it, then replace the very last char ";" wit...
by gto
13.03.2006, 23:24
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Cannot install in Delphi5
Replies: 7
Views: 2091

Re: Cannot install in Delphi 5

I cannot install into Delphi 5. There is a required file dateutils which does not exist. I then tried the other suggest of installing the earlier 2004 version but this won't work either because when you install ZComponent you get an error saying [various things] have already been registered by pack...
by gto
09.03.2006, 20:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Firebird 1.5 and BLOB (as text)
Replies: 3
Views: 1582

Firebird 1.5 and BLOB (as text)

Hallo =) here I'm, again and again Today, my problem is with BLOB type (firebird 1.5) Every time that I post a text to my BlobField (subtype :1 - text, BlobType: ftMemo) through a DbMemo, FastMM4 reports it as leaked memory (all the text from the DbMemo). I tried to go deep into zeos code, but wasn'...
by gto
24.02.2006, 15:26
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZeosLib Components Cached Updates
Replies: 6
Views: 1774

Hey zippo, means something like this: Today, the component cached updates store the modifications in your own cache, each component has one cache, independant from others without commiting to database, the modifications made in a dataset don't reflect in another. I think that's the way it work's tod...
by gto
20.02.2006, 15:56
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: OnCalcFields and RecNo
Replies: 3
Views: 1164

hum... maybe the RecNo isn't updated when calcfields is executed

An idea is to deal with some database field (something like add another field called "code", "index"..) or even access the RecNo property directy, as you don't make any changes to it :)
by gto
20.02.2006, 15:49
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Batch Insert
Replies: 4
Views: 1343

=\
I've tested a bit more deep than before and faced the same problem :(

One workaround is to switch off the autocommit option in ZConnection and try to insert all records, one by one, before trigger the commit procedure

it will be a "hard batch", dirty but functional :D
by gto
17.02.2006, 16:18
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Batch Insert
Replies: 4
Views: 1343

try this:

get an TZConnection and a TZReadOnlyQuery linked, up and running

pass the "batch" query to ReadOnlyQuery using
TZReadOnlyQuery1.SQL.Text := MyQueryText;

Use the TZReadOnlyQuery1.ExecSQL method

that is! :)
hope it helps