Thanks Andrew and Bob. Unfortunately, I'm using an sqlite database and as far as I can tell from the docs, it doesn't have a binary data type. I could define a column as BINARY but it would end up as NUMERIC in sqlite's world. I'll give it a whirl though.
I've actually now written a function to convert a multidimensional array into a string with one line for each of the first level keys and each line containing the keys separated by tabs, ending up with the value in the lowest level key. That way I can just store the text string in the db without a problem, and I also have a simple command to assemble the strings into an array when I read them back from the db. So if Array["abc"]["def"] contains "xyz", the resulting line would be "abc<tab>def<tab>xyz". This was the cause of my other recent posts about what happens when the last item in a string is empty. Provided some interesting recursion opportunities! Pete Molly's Revenge <http://www.mollysrevenge.com> On Mon, Aug 22, 2011 at 9:49 AM, Andrew Kluthe <and...@rjdfarm.com> wrote: > It sounds to me like binary is the data type you want here. > > -- > View this message in context: > http://runtime-revolution.278305.n4.nabble.com/Confused-about-storing-arrays-in-a-custom-property-tp3757539p3760664.html > Sent from the Revolution - User mailing list archive at Nabble.com. > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
