Home > database >  Pb ole database blob images problem for help
Pb ole database blob images problem for help

Time:09-19

Masters, I see many about the images stored in the BBS posts, some stored in the database path, others by updateblob store large binary data, I recently developed an employee profile software, it want to involve employees the pictures shown in datawinow problems, to facilitate sharing, adopts the second way to store data, but there was a problem in the display picture, I have to save images to essentially updateblob way,
My way through the grid to establish data window, and then insert the OLE Database Blob controls, the definition has been set (keyclause=& lt; CARDS=: cards> Oleclass=& lt; Paint. Picture> Clientname=& lt;" Corresponding record id is "+ cards> Name=blob_1), but why in dw_1, retrieve () do not display pictures, just opened the drawing board, double-click the control blank inside, is my configuration has a problem, still lack what steps, consult everybody,,,

CodePudding user response:

His head up first,

CodePudding user response:

My first Posting on BBS, guarantee the junction post, ask everybody to help,

CodePudding user response:

The building Lord your problem solved?

CodePudding user response:

Db ole must double-click to enter the corresponding control to draw from the interface, and then by the db ole automatic encapsulation and deposited in the corresponding database,
Can't deposit the graphics file directly to the database, because the db ole fail to detect data, without its packaging

CodePudding user response:

In DATAWINDOWN shown in pictures and in the window display images are different, the window you can directly add a picture control can, of course with selectblob statement to take out the blob, reoccupy setpicture (blob); And the images in the datawindow control is a file name, when the database is under construction, it takes two to make a column, a column is a blob - save image binary files, another column string - save the image file name, and then build datawendow, select the image file is as the picture shows, in the query, add selectblob statements, retrieve the images of blob, in its according to save the file name written in the default directory of the program, so as to make the picture show in the datawindow,
  • Related