Page 1 of 1

Can't save image in tdbwidgetgrid

Posted: 21.02.2008, 20:08
by wahono
In MSEgui, I can't save image with tdbwidgetgrid. I use MySQL4.1. Test project about 500kb compressed. I was upload this project to MSEgui forum (topic : out of memory message with tskincontroller'. From transaksi->transaksi, in column 3(Gambar), right click at 'buka gambar'.

If you want I upload to this forum, I will do it.

regards,
wahono

Posted: 22.02.2008, 12:53
by mdaems
Can you tell if it's a Zeos problem or a problem with the MSE wrapper?

Mark

Posted: 22.02.2008, 15:46
by wahono
For more 2 days Martin was tried to fixed this bug and He ask you that this is Zeoslib bug. Because when I disconnect tmsezquery with blob fields show this message (compiled with -gh to trace heap memory).

Marked memory at $025F6518 invalid
Wrong signature $7AED1FFB instead of 49529CAA
$00410416
$00528667 TZROWACCESSOR__DISPOSEBUFFER, line 403 of
C:/MSEGUI/lib/zeoslib/dbc/ZDbcCache.pas
$005BAE64 TZABSTRACTRODATASET__FREERECORDBUFFER, line 1378 of
C:/MSEGUI/lib/zeoslib/component/ZAbstractRODataset.pas
$004B91C1
$004B7A99
$004BB78E
$006270CC TMSEGRAPHICFIELD__DESTROY, line 284 of
C:/MSEGUI/lib/common/db/msedbgraphics.pas
$0043C9FF
$00417D9B TWIDGET__DESTROY, line 4773 of
C:/MSEGUI/lib/common/kernel/msegui.pas
$0042BF9A TCUSTOMMSEFORM__DESTROY, line 647 of
C:/MSEGUI/lib/common/widgets/mseforms.pas
$0042E2B1 TCUSTOMDOCKFORM__DESTROY, line 1478 of
C:/MSEGUI/lib/common/widgets/mseforms.pas
$00408832
$004212DD TWIDGET__RECEIVEEVENT, line 8949 of
C:/MSEGUI/lib/common/kernel/msegui.pas
$004353BB TCUSTOMEVENTWIDGET__RECEIVEEVENT, line 3589 of
C:/MSEGUI/lib/common/kernel/msewidgets.pas
$0042C86A TCUSTOMMSEFORM__RECEIVEEVENT, line 854 of
C:/MSEGUI/lib/common/w

I don't know exactly, sorry.

regards
wahono

Posted: 23.02.2008, 19:27
by mdaems
I had some time to check your problem today. So I downloaded the Acosys project I found in the thread. Got it compiled. Managed to connect. But now... How to reproduce the error? Maybe you best post the right version here, together with intstructions about how to create the error situation.

I found some other 'problem' with your project. Your connection tries to open before the login form is shown. Didn't check why. This means you need to hard code a valid user and password to connect before the login form is displayed. Here root has a password. So initial connection failed.

Mark

Posted: 24.02.2008, 16:22
by wahono
To reproduce the error, please you compile mseide with -gh option to trace heap memory. If it isn't compiled with -gh, this error cannot reproduce. Open my project, in form datamodule, please change user and password to your mysql account. than connect zcon.

Open form frmtransaction, than activate sqlrentitem, this tmsezquery use blob field to load/store image. If tmsezquery is active than please make it inactive. Error will shown. I hope you can understood my explaining with bad english. :)

regards,
wahono

Posted: 24.02.2008, 16:34
by wahono
My connection not connected before login form, just created and when finish compiling I disconnect tzconnection as default. My connection is connected when 'ok' button from login form is pressed. Don't forget this error can't reproduce when without -gh option for make.

Posted: 24.02.2008, 18:36
by wahono
For easy debugging, I upload simple project. And in this project I foud other bug, with executedirect I can't create field with name 'name' and 'description'. You can try with click button 'create DB'. If I use MySQL Administrator, I can named field with 'name' and 'description' too. Crash in above posting can be see when tmsezquery is conneting than you click 'disconnect' button.

Posted: 26.02.2008, 21:17
by wahono
I think it causes by tmsegrapficfield and caching blob in zeoslib, especially when destroying from memory (issue on destroy order). Could you share for me example in Delphi how Zeoslib can do to save image to database?

Where we can get examples Zeoslib?

thanks
wahono

Posted: 26.02.2008, 22:06
by mdaems
There's a examples directory in the zeoslib distribution/SVN (eg. see 'blobs' project). I've seen some post here on the forum as well.

Didn't have time again to look at it. Maybe tomorrow. (Wednesday usually is Zeos day :wink: )

Posted: 27.02.2008, 17:15
by mdaems
OK. I've been able to generate the error now. You did forget to mention I had to insert an image to the created table...
Searching...

Mark