Who see picture form directory extern

cpina · 2006-03-10

It is possible to assign a direction(address) of file to a control picture box or image.

Thank you

andrejsm · 2006-03-10

Hi,
No, it is not possible. But some time ago, I think, it was Navision 3.60, there were manufacturing menu with flowcharts. The main idea of this flowchart was to place controls on the form and import previously saved bitmap.
Link to Graphical Navision Demo tool: http://www.mibuso.com/dlinfo.asp?FileID=349

Saro · 2006-03-10

You can create an empty blob field in some table (i used the company information table to add a few blob fields which stay empty except for at runtime) when you wish to show the picture from your hard drive (or network drive) you can import the picture internally to the BLOB field and show it, and when you close the form or report the blob will be cleared and hence will not take the space in the database.

cpina · 2006-03-13

Saro wrote:

You can create an empty blob field in some table (i used the company information table to add a few blob fields which stay empty except for at runtime) when you wish to show the picture from your hard drive (or network drive) you can import the picture internally to the BLOB field and show it, and when you close the form or report the blob will be cleared and hence will not take the space in the database.

Savatage · 2006-03-23

Saro wrote:

You can create an empty blob field in some table (i used the company information table to add a few blob fields which stay empty except for at runtime) when you wish to show the picture from your hard drive (or network drive) you can import the picture internally to the BLOB field and show it, and when you close the form or report the blob will be cleared and hence will not take the space in the database.

Can you explain this a bit more.

I've been playing around with keeping all my item pics in a mapped drive called p:\ (for pictures)

I would like the pic to import into Item.Picture BLOB only when needed.
The perfect place would be OnAfterGetRecord but you can't modify the database from this trigger.
Or
Get Pic OnOpenForm & Clear pic OnCloseForm doesn't work either. can you explain a bit more your solution thanks.

Meanwhile I'll check up on this
Real-time Multiformat Picture Convertor JPG & GIF

http://www.mibuso.com/dlinfo.asp?FileID=92

Savatage · 2006-03-23

Nevermind
[Item Card]

OnAfterGetRecord()
SETRANGE("No.");
PictureExists := Picture.HASVALUE;
IF EXISTS ('P:\'+"No."+'.BMP')
THEN
Picture.IMPORT('P:\'+"No."+'.BMP',FALSE);
CALCFIELDS(Picture);

Works Fine.

& My Database size dropped by 4% \:D/ after deleting all the item pictures saved in the BLOB

Who see picture form directory extern

Comments

Categories