[libreoffice-users] Re: save binary files in MySQL DB via libreoffice base

Le 28/11/11 22:34, Andre Charbonneau a écrit :

Hi Andre,

> But it seems that the form creation wizard assigns an image file input
> control to the blob type, which only allows me to select files of image
> type (extension).
> So I tried changing it to a simple file selector control, but I can't
> seem to be able to attach that control to a column in my database (i.e.,
> there is no 'data' tab on the control properties).
>
> So now I'm stuck... :-(
>
> Anyone had a similar issue before and might point me in the right
> direction?

BLOB/CLOB support via the LibreOffice (and OOo) UI/API is...incomplete.
As you have found out, direct support only extends to image files.
Saving and retrieving a datastream in a user friendly way
requires...patience and some degree of programming knowledge.

You'll probably want to look at Andrew Pitonyak's Base macro programming
guide, but I can also recommend Roberto Benitez' book called :

Database Programming with OpenOffice.org Base & Basic


And, if you read French, Laurent Godard/Bernard Marcelly's book called :

Programmation OpenOffice.org

Now take a deep breath, and dive in...

Alex




-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted