Zeoslib Portal

I've noticed that the problem arises when I try to INSERT The SQL generated by the component is as shown below: INSERT INTO foyers (PK_ID_FOYER, NOM, ADRESSE, VILLE, CODE_POSTAL, FK_ID_PAYS, TELEPHONE, CONTACT) VALUES (:PK_ID_FOYER, :NOM, :ADRESSE, :VILLE, :CODE_POSTAL, :FK_ID_PAYS, :TELEPHONE, :CON...

Hi there, After labouring over ZUpdateSQL for a week, I've concluded that the component is buggy when adding parameters. At runtime, I've noticed that sometimes, the number of parameters I see in the Lazarus IDE object inspector is not the same as the number of parameters in the Params property dial...

@EgonHugeist A) "Do I need that UpdateComponent" I added the ZUpdateSQL component when I noticed that the ParamCount property of the ZQuery was giving faulty values. For example, I added 6 parameters to a ZQuery but ParamCount returned 0! ParamCount worked OK for ZUpdateSQL though. Is thi...

Hi there, Inserting POST before APPLY UPDATES results in a EDatabase error: operation not allowed, dataset "qryWrite" is not in an edit or insert state. This is understandable because I did not issue an OPEN command earlier. If I add OPEN, the error becomes "SQL query is empty". ...

Hi there everyone, I need a fresh pair of eyes for a problem I'm having. I'm trying to update remote tables using a ZQuery and a ZUpdateSQL component. I want to use one ZQuery and a ZUpdateSQL for each of the tables that I want to update. I have 8 tables to update. The code snippet for updating one ...

Hello everyone, I recently upgraded to Firebird 2.5 & I discovered that my installed Zeos version (6.6.6) could not connect to Firebird databases using the new fbclient.dll I downloaded & installed Zeos SVN Rev 878 & successfully installed it for Lazarus 0.9.31 without problems. But when...

It is possible. I've seen it done with data components other than Zeos. Like trupka said, Delphi's TClientDataSet is one example. Another is Lazarus' TMemDataset & TBufDataset. RX Components' TRxMemoryData that works in Delphi & Lazarus also does this. But these are client side components. I...

I want to store the data - a record or the entire dataset - not the properties, to a stream. All I found was
ZQuery1.Properties.SaveToStream
ZTable1.Properties.SaveToStream

so I was wondering how it works.

Does anyone know how I can save a Zeos dataset to a stream?

Thanks for your assistance.

Zeos SVN repo works perfectly fine while I'm writing this. It's probably network issue. It's impossible to resolve this through forum, I can give you only a few general tips: - you cant ping zeos.firmos.at. That's OK. - try to capture some network traffic and see is network connection established a...

You're doing OK and I just tested checkout from trunk.It also works OK so problem is somwhere else. Doesn Tortoise reports some error or just hangs? Firewall / provider issues maybe? See the attached screenshot for the error messages Tortoise SVN reports. The French error messages say that "an...

Wild_Pointer wrote:hello JD,

Please use svn://zeos.firmos.at/zeos/trunk

Good luck!

I tried it with Tortoise SVN (using SVN Checkout) & it didn't work. See the attached screenshot. What am I doing wrong?

Hello everyone,

Can anyone give me a good link to the svn version of Zeos? I hear there are lots of bug fixes in the svn version & I'm keen on updating my Zeos 7 alpha.

http://svn.zeos.firmos.at/zeos/trunk does not work for me. I use TortoiseSVN.

Thanks

Hello everyone, I need some help with saving a Zeos query and a Zeos table to a memory stream. I would also like to know how to load a Zeos query and a Zeos table from a memory stream. I've seen ZQuery1.Properties.SaveToStream ZTable1.Properties.SaveToStream but I don't know how they really work. Th...

I found the answer on this page

http://zeos.firmos.at/kb.php?mode=article&k=6

Thanks for taking the time to read my posting.

Hi there everyone, I am using the code below to manage transactions in my application. procedure TForm1.DoTransaction(DataSet: TDataSet); begin with ZConnection1 do begin if not AutoCommit then begin StartTransaction; //Gives me an error 'invalid operation in non AutoCommit mode' try Commit; except ...