Hi, I'am using Delphi5 and TDatabase/TQuery component with SQL2000 in BDE. But when you paste image to the TDBImage control and try to save, system always reply : Invalid BLOB Length. The data field in SQL2000 I've set to Image type. Please help me!

http://delphi.ktop.com.tw/topic.php?TOPIC_ID=20127 http://delphi.ktop.com.tw/topic.php?TOPIC_ID=18997 http://delphi.ktop.com.tw/topic.php?TOPIC_ID=161 --- --<-<-<@

I have set BLOB SIZE / BLOBS TO CACHE to 64 both in Database / Congfiguration of BDE, but the problem still display even with a jpg image of 7KB. So BDE could not deal with SQL2000 on image type field with TDBImage field?

在 TDatabase 元件上點兩下, 再點選 Default 鈕 然後在左邊空白的部份更改 BLOB SIZE / BLOBS TO CACHE 這兩個值試試. --- --<-<-<@

I have tried, both in Delphi5 / Delphi6 Environment. But both failed. You could try the project in uploaded zip file. Environemnt: - SQL2000 database with a table of two field: EmpNo char(5) , EMPic Image - BDE object with MSSQL type (could find in Database1 default ...) Could you test why BDE failed on this operation? Thanks http://delphi.ktop.com.tw/loadfile.php?TOPICID=10790688&CC=241332 發表人 - patrickz 於 2003/07/22 21:28:22 發表人 - patrickz 於 2003/07/22 21:31:11

http://delphi.ktop.com.tw/topic.php?TOPIC_ID=21727 http://delphi.ktop.com.tw/topic.php?TOPIC_ID=29985 --- --<-<-<@

I checked the 2 links, both situation are not same as my case. My problem could be checked in my uploaded file. But whatever, from those case study, I tried using ADOConnection then very problem is sloved. Looks like kind of operation could only deal with paradox... but not SQL2000. It's really a regret. Thank you quick response. Later to see I could help others....(:-)