The pictures save to blob field has problems!BUG!!!!

[capelin]

Version:Unidac3.5.0.12
Database:Mysql 5.x
Table:Create Table test ('id' int(11),'img' Blob);
Code:
UniQuery1.Edit;
TBlobField(UniQuery1.FieldByName('img')).LoadFromFile('c:\a.jpg');
UniQuery1.Post;


The Old Version(3.0.0.9) No Problems!!!!

[capelin]

No Replay?

[AndreyZ]

Hello,

Please specify the exact IDE you are using and the SQL code you have in the UniQuery1.SQL and UniQuery1.SQLUpdate properties.

[capelin]

I have already set up the SQL statement(UniQuery1.SQL and UniQuery1.SQLUpdate), but still wrong!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

But old Version(3.0.0.9) No Problems.

[capelin]

UniQuery1.SQL.Text:='Update test set img=:img';
UniQuery1.Params[0].LoadFromFile('c:\a.jpg',ftBlob);
UniQuery1.Execute;

But still wrong!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

But old Version(3.0.0.9) No Problems.

[AlexP]

Hello,

Unfortunately we can not reproduce the problem.
Please try to reproduce the problem in the Pictures UniDAC demo project.
Also please send a complete small sample to alexp*devart*com to demonstrate the problem and please specify the version of your IDE.

[capelin]

The same procedures, in the old versions can run, in the new version can not be executed.

Version:Unidac3.5.0.12
Database:Mysql 5.x
IDE:Delphi7
System:WindowsXPsp3
Table:Create Table test ('id' int(11),'img' Blob);
Code:
UniQuery1.Close;
UniQuery1.SQL.Text:='SELECT * FROM test WHERE id=1';
UniQuery1.Open;
UniQuery1.Edit;
TBlobField(UniQuery1.FieldByName('img')).LoadFromFile('c:\a.jpg');
UniQuery1.Post;

Submit error!

Old Version (Etc.3.0.0.9 pre) No Problems

[AlexP]

Hello,


Please try to execute the following code:

try
UniConnection1.ExecSQL('DROP TABLE test;',[null]);
except
end;
UniConnection1.ExecSQL('Create Table test (id int(11),img LongBlob);',[null]);
UniConnection1.ExecSQL('INSERT INTO test(id) VALUES(1);',[null]);
UniQuery1.SQL.Text:= 'SELECT * FROM test WHERE id=1';
UniQuery1.Open;
UniQuery1.Edit;
TBlobField(UniQuery1.FieldByName('img')).LoadFromFile('e:\1.jpg');
UniQuery1.Post;

if error persists, please set the UniQuery.Debug property to true and specify the result SQL statment.

[capelin]

But The 3.00.0.9 is OK!!!!!!!!!!!!!!!!!!!!!!!Less than this version is correct,More than this version all have a problem!!!!!!!!!!!!!!!!!

But The 3.00.0.9 is OK!!!!!!!!!!!!!!!!!!!!!!!Less than this version is correct,More than this version all have a problem!!!!!!!!!!!!!!!!!

[AndreyZ]

Unfortunately, we still cannot reproduce this problem. Please try composing a small sample to demonstrate the problem and send it to andreyz*devart*com. It will be the fastest way to resolve this problem.

[capelin]

Not only picture file all documents saved to blob field have a problem.
A mail sended to andreyz*devart*com

Version:Unidac3.5.0.12~14
Database:Mysql 5.1.x
IDE:Delphi7
System:WindowsXPsp3

You just test can be found this problem, but but you have never been solved, was disappointing.

[AndreyZ]

Thank you for the information. We have fixed this problem. This fix will be included in the next UniDAC build. As a workaround you can use the UTF8 charset instead of GBK.