Zeoslib Portal

aperger

Hello,

CAn anybody help on this:
http://zeosbugs.firmos.at/bug_view_adva ... ?bug_id=30

Thanx
ATi

aperger

I can save Blob without any problem. I would like to set the parameter BEFORE setting SQL.Text, because there is an 'If' for UPDATE and INSERT, but their parameter is the same. But it seems to be impossible... :( try to create a function which set the Params object! procedure setXXXParams(Params:TP...

aperger

hello, Fist of all, set the SQL.Text, and set the parameters, after call ExecSQL command on your TZQuery object. IN this way you do not need to call CreateParam() just you sould set the values... .... BUT on MYSQL I have problems to save BLOB fields into the DB. DM.iCsoportok.SQL.Text:='INSERT ... '...

aperger

Maybe your client side encoding is not the same as the server codepage... it can be different...

aperger

Code: Select all

  // DB codepage
  ZConnection.Properties.Values['codepage']:='latin2';

  // Client side encoding
  ZConnection.Properties.Values['client_encoding']:='latin2';

So... you can set your onw... it works under Linux/Kylix 3.

aperger

2. file

aperger

Hi,

I attache the updated package structure for Kylix3 and Delphi 2005, and I found a small BUG in the package name in Delphi 2006 directory. You can see my modification in a PATCH (Diff_for_kylix3packs-And-d2005packs_rev210.zip) and in a "hardcopy" (ZeOS-TestTrunk.zip) too.

Attila

aperger

jorgen wrote:How do you avoid receiving Firebird message "deadlock update conflicts with concurrent update" when 2 or more clients are changing records in the same table ?

Hi

I think you should use trasnactions intead of record locking!!!!
Attila

aperger

Hi

I was not interested in to do this package modification.. but it is ready at the monent, but on FC4/Kylix 3 when I click on the TZUpdateSQL components to call it's on editor Access Violation is raising.

I attache my patch: patch_kylix_packeges_rev186.patch

Attila

aperger

Hi

It was not a requirements for me to do this... If it is ready I can test it and I will send you a reply.

Attila

aperger

Hi Mark (Part2)

I use the same source to save streams into BLOB with ZeOS. If I use mysql protocol the code is not working, If I use ado, postgresql, firebird the program is working.

CODE at the top : procedure ReadBlobField, procedure WriteBlobParam

aperger

Hi Mark, The problem: I. If the contect of the BLOB field is an XML file, the XML parser can not parse it. II. If the content of the BLOB field is an IMAGE, the result is incorrect on the screen. The biggest part of the picture is black at the top. I don't know where is the bug at saving or at readi...

aperger

Hi Developers,

Rev.108 cause the same problem (D7 - CLX). How can I save and restore XML file or IMAGE into/from a MySQL database?

aperger

Hi,

Please use the "SRC" as your library directory, in this way the kylix will compile the *.PAS files again (as correct *.dcu) when you refer them in your projects.

aperger

Hi developers, I can read and write BLOB field into my databases with ZeOS. Unfortunatelly if I use mysql-4.1/mysql-5 protocol on a MySQL server (4.1/5), I can not get back the same content of the BLOB field as it was saved. The following procedures were tested and used with the following protocols:...

Zeoslib Portal

Search found 129 matches

PostgreSQL and XML into BLOB

[bug_fixed] Update structure of packages (k3, d2005, d2006)

Re: Deadlock

MySQl 4.1/5 & BLOB fields