Hello guys

Hello guys,

I would have a table of firebird db with field that contains multi values

example of data:

first_name varchar(20) = "Antony"
colors varchar(30) = "[ red, green, blue] "

How can I do it ?

and How to select the data from array?

I tried with TArrayfield of Firebird ... but I have problem to retrieve the data with "where" condition

I tried this demo embarcadero
http://docwiki.embarcadero.com/CodeExamples/Tokyo/en/FireDAC.InterBase_Arrays_Sample

Do you have suggestions?

regards
Antonello
http://docwiki.embarcadero.com/CodeExamples/Tokyo/en/FireDAC.InterBase_Arrays_Sample