Geregistreerd: di aug 24 2004, 11:35 berichten: 20
Hi,
i habe some problems with Blobs/Text-Fields. It all began with the problem, that the component doesn't return the values of VARCHAR fields with german "umlaute" like äüö. As soon as i enter one of this characters into a varchar field i get an empty result via Table and Query.
So i putted all text in a Text-Field. Here the äüö works!
But now i have another problem. Some times a row returns an empty result in the Text-Field and also in a BLOB image field. When i close the table and reopen it it works again. This is no regular event. Sometimes all rows (ca. 10) will be returned correctly, sometimes one of them gets empty fields. It's not always the same row with the bug. It really gives bugs on random rows.
Geregistreerd: di aug 24 2004, 11:35 berichten: 20
Regarding äöü:
I downloaded your sample. When i start your compiled Samples.Exe and insert in the simple-table this characters, then post. Close the programm and reopen the table it works fine. But when i open the .dpr, compile the program with my delphi7, and then insert this characters it will be showed when i post it. Then i close the program and reopen the table and the whole field will not be displayed anymore. When i open the table with your compiled exe it works...
The blob/text-problem occurs on several similar tables. Here is one for example:
CREATE TABLE "sektor" ( "id" INTEGER PRIMARY KEY NOT NULL, "sektor" INTEGER NULL, "folge" INTEGER NULL, "bezeichnung_d" TEXT NULL, "bezeichnung_e" TEXT NULL, "langtext_d" TEXT NULL, "langtext_e" TEXT NULL, "picture" BLOB NULL )
It contains my database, my sqlite3.dll, a compiled exe and the demoproject.
You will see that sometimes it returns empty fields, sometimes it works perfect. Just click the "reopen-table" button several times and you will notice the bug.
Geregistreerd: wo jan 25 2006, 04:34 Woonplaats: groningen (NL) berichten: 1561
Actually I cannot run your sample due to a component set i dont have/use. I remodified your sample a bit using standard components and can't find problems at first sight...
Geregistreerd: wo jan 25 2006, 04:34 Woonplaats: groningen (NL) berichten: 1561
Unfortunately no. I even haven't reproduced it as i thought earlier. You database field 'bild' was empty after a few rows. I cannot load you binary data as an image. The TDBImage generates an error. I don't have the quantumgrid available here, so I cannot reproduce. My sample app works as expected.... albert
Geregistreerd: di aug 24 2004, 11:35 berichten: 20
That's because it's a JPEGImage. But the problem also occurs with the Memo-Field. You can see it with a standard grid also. Just look at the fields langtext_d and picture.
When you refresh you will see that some times both fields are with data on all rows and some times there is one ore more fields without data (delphi will write Memo instead of MEMO and Blob instead of BLOB).
