Hi ..
Is there any possible to store the images in baan table or database??
If yes,please explain in detail.

Thanks..In Advance..

Whats your exact requirement please???

Hii
eg:- In purchase order ,user select one item then it shows corresponding item-image.
so i want to store image in database .Is it possible ?

I would recommend you to look at Infor Document Management (IDM), which is part of Infor OS. IDM is integrated with Infor LN and can show images in a context app within Ming.le.

Hi..JaapJD
Thanks...for your reply ..

Hi you can use next commands: db.blob.append(),db.blob.append.xml(),db.blob.clear(),db.blob.read(),db.blob.read.xml(),db.blob.read.xml.ns(),db.blob.size()

or librarry ttdllblob:

function extern long ttdllblob.load.blob.from.file(
domain ttadv.blob i.blob.locator,
const string i.input.file() )

Expl: This function loads the contents of a file into a BLOB.
The current database transaction is not committed/aborted by
this function; the caller needs to take care of that. (Typically,
this function is invoked inside a "select for update" statement.)
Pre: The database record containing the BLOB needs to be locked
Post: The database record has been updated (not yet committed)
Input: i.blob.locator - BLOB locator, fetched from database
i.input.file - File to be read
Output: -
Return: 0 - Success
-1 - File does not exist
-2 - Clearing the BLOB failed
-3 - Reading from file failed
-4 - Writing the BLOB failed
-5 - Error opening input file

function extern long ttdllblob.save.blob.to.file(
domain ttadv.blob i.blob.locator,
const string i.output.file() )

Expl: This function copies the contents of a BLOB to a file.
Pre: -
Post: -
Input: i.blob.locator - BLOB locator, fetched from database
i.output.file - File to be written
Output: -
Return: 0 - Success
-1 - Error reading BLOB size
-2 - Error opening output file
-3 - Error reading BLOB data
-4 - Error writing to output file
-5 - Error closing output file

Hello

I think that it depends of which version of Baan / Infor LN are you using ?

In Infor LN 10.5 some tables are already defined to have a imagen attached to the record.
For instance tcibd001 (master items) has the field tcbd001.imag and you can attach one image to each item. (its seems that in the future more than one imagen could be attached to one item)
The images are saved in a directory in the server.
The images can be connected with the item directly in the maintain item session.


regards
Gerardo Arias