Read color from DB

Trying to read DB field, defined as color on DB

[code]Dim c as color

c = rs.field(“acolor”).DoubleValue[/code]

I get a compile error of “mismatch error”; have tried changing the DoubleValue to other type values and still get an error.

There is no color field for SQLite. RecordSet.Field returns a SQLiteDatabaseField if you wanted to check. Using the auto type .Value might work, but I haven’t fiddled too much with iOS / new framework to tell you for sure without testing.

I would store the color as a string, either in rgba or hex values and restore it from those.