I have an existing SQLite database with fields containing arrays.
How LibreOffice Base can handle those types of datas?
And, let’s say I have an array filed containing {A,B,C}, how can I link checkboxes like with my other databases? The order isn’t important, it can ne {B,C,A} or {C,A} or anything else.
But i don’t know how to handle this in LibreOffice Base with forms and it’s not documented.
It isn’t documented because it isn’t implemented. Internal HSQLDB doesn’t support datatype array, internal Firebird database doesn’t support …
I only know PostgreSQL, which supports arrays. Could fill these arrays through macros, could show the content in a form through macros, but all form controls will connect only to one value through the GUI, not to an array.
I would never use arrays, use a new table connected by foreignkey and you could save the same kind of data.