Hello I have created a database archive on Base with images in LONGVARBINARY. But when I try to add the actual Photo file I get this error when I try to save:
S1000 General error java.util.NoSuchElementException: Cannot invoke “orghsqldb.lib. Storage.seek(long)” because “this.dataFIle” is null in statement [UPDATE 'Ceramic fabrics" SET “micro.picture” = ? WHERE “ID” = ?]
Anyone knows how to fix this?
v.
Seems there are no data available for input.
Some hints for working with images in LO-Base and databases:
If you try to add many big images like normal photo files you will get a NULLPointerException. All input since the last opening of the database file will be lost (internal HSQLDB, see bug 92936)
You will have problems to get the original images back from the database without knowledge in SQL and macro-writing. So the better way is to move all images for a database in a separate folder and link the images to the database. The imagecontrol of Base forms will show this images also. You have only to link the imagecontrol to a varchar-field, not a LONGVARBINARY.