image

[filipe26]

hi i have a dbimage and i want to store the image in my paradox table.I have datamodule.dbimage.value:=......
What i have to put there??i made:

if abrir.Execute //Topenpicturedialog// then
foto.Picture.LoadFromFile(abrir.FileName);

and now hor to put this picture in the table?

 

[fruNNik]

You have to to put it into a BLOB field,
I dont know if Paradox supports it though...

- fruNNik

 

[filipe26]

yeah i know and i have it in the table ,it's a field of graphic type which corresponds to blob but waht i want to know it's the sintax of it.

 

[fruNNik]

You use a TBlobField to assign the image to it:

if not (Query1.State in [dsInsert, dsEdit]) then Query1.Insert;
Query1Images.Assign(Image1.Picture.Bitmap);
Query1.Post;

where Query1Images is a TBlobField

hth

- fruNNik

 

[filipe26]

When i post everything occurs fine withou errors but when i scroll thru another records the picture remains.I dont know if it records the image because in my database desktop i only see <Blob Graphic>.

 

[fruNNik]

I Guess you are using a dbgrid for viewing the dataset ?, that wont display the picture (without help).
You need to display the image in a separate control. Catch the OnChange event of the Dataset and assign the data of the blobfield to an image.

hth

- fruNNik

 

[filipe26]

Yes but i have a dbimage linked to the table not a dbgrid.

 

[fruNNik]

Well, that should work (i think). Did you assign the field property of the DBImage to the Blobfield ?

- fruNNik

 

[filipe26]

yes i did