In review, I read the tutorial here: http://www.kdedevelopers.org/node/2163 and asked how to import images in batches
Jaroslaw Staniek provides a nice answer here: http://kexi-project.org/wiki/wiki/index.php?HOWTOs%2FDatabase%20Handling This advice mostly worked for me, but here are few comments that might help other folks trying to do the same thing. First here is a perl script to convert a binary file to a hex string, which is needed to create the BLOB data: sub Bin2HEX { my $bin_file = shift; open (BIN, "$bin_file") or die "Could not open $bin_file\n\n"; binmode BIN; my $bin; while ( read (BIN, $bin, 1 ) and printf("%02X", ord($bin))){}; close BIN; } Lastly, when using images in forms, if I declare an image box read-only, no image is displayed, and the database crashes when I close the form (signal 6). I'm using Kexi 1.1.0, so maybe an update will help. Otherwise it works well so far. Thanks, Andrew Hufton -- View this message in context: http://www.nabble.com/Importing-Images-%28BLOB-data%29-tp14255116p14333181.html Sent from the Kexi General mailing list archive at Nabble.com. _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
