Zeoslib Portal

I tried this with Firebird, works ok.
Except that I use zquery.fieldbyname() in stead of persistent fields. But that shouldn't be a problem.
Guido

maybe you better put the variable in a param

zquery1.Close;
zquery1.sql.clear;
zquery1.sql.add ('select * from quotes where usuario_id = :yourparam');
zquery1.parambyname('yourparam').value := zquery2usuario_id.asinteger;
zquery1.Open;

guido

in unit1 you are assigning the result of p.q to ds.Dataset, and in p.q you assign qu to ds.dataset, but then q returns without result assigned.
maybe it works better if you replace in unit2

ds.DataSet:=qu;

with :

result := qu;

guido

Well with me it works fine wether I add the properties or not. Maybe it is related to fb1.5.
Concerning hard and soft commit, I suggest you read this:

http://tech.groups.yahoo.com/group/fire ... sage/34797

(Helen is/was(?) member of the development group of firebird.)
Guido

JavaPauloMG, i copied your code into a new app in delphi5, with zeos665-stable on winxp sp2 with a fb2.1 database. it works ok, without error!
guido

don't know, but after query.open I always do query.first to locate cursor on first record. don't know if query.open creates cursor in zreadonlyquery...
(just found out that lazarus 0.9.28.2; fpc 2.2.4 and zeos 6.6.6-stable gives problems with 'bookmarks'... will report later)
guido

Maximum blob size is (according to Operation Guide):
1Kb page size => 64 Mb
2Kb page size => 512 Mb
4Kb page size => 4 Gb
8Kb page size => 32 Gb

so, if you want to load larger blobs, adjust the page size of your fb database.
guido

sorry if i am wrong, but i thought that the difference between the ztable and zquery is that ztable fetches the whole table, and zquery just the 'queried' resultset ?
guido

try setting the option : MYSQL_OPT_CONNECT_TIMEOUT
then there would be something like a persistent connection to mysql, but i dont know if zeos supports it.
guido

certificates (.pem files) have to be generated and signed with a program like openssl. essentially it is the same as used with https in browsers, where the certificates are mostly installed together with the application

guido

Hi Mark, this is from my lpr file: program project1; {$mode objfpc}{$H+} uses {$IFDEF UNIX}{$IFDEF UseCThreads} cthreads, {$ENDIF}{$ENDIF} Interfaces, // this includes the LCL widgetset Forms { you can add units after this }, MainformUnit, LResources, zcomponent, persoonsgegevenswijzigenunit, OgmBoe...

Hi Darkbow, First of all, why not the latest lazarus version? As I have no experience on linux or so, I can only give some tips on windows. Both 6.6.5 abd 6.6.6 should install. For Lazarus it is preferable that your username/profilename contains no spaces. And if you have for example an ampersand (&...

Hi Mark, In runtime, I have the TZConnection on the MainForm, connected and well, when I try to create another form with the TZQuery, which uses the Mainform.ZConnection. For reason of the creation order, I tried shuffling with the objects in the .lfm of the new form, but that didn't help. Do you th...

I have this strange behaviour in lazarus 0.9.26.2 fpc 2.2.2 on winxpsp2: a TZquery (zeos6.6.6) on a form with the Connection property assigned in designtime, raising an exception in the form.create : procedure TZAbstractRODataset.CheckConnected; begin if Connection = nil then raise EZDatabaseError.C...

No, there isn't. If you are in charge of the server, you can use stunnel (opensource, easy). Or openssl (opensource, not so easy). There is also lNet for lazarus. Guido CORRECTION : yes there is (sorry!) : Properties.Strings = ( 'MYSQL_SSL=TRUE' 'MYSQL_SSL_CA=D:/mysql/certs/ca-cert.pem' 'MYSQL_SSL_C...