saving and recalling colors in DB

General
1

Hi there… I’ve created a database for my app.
The database works great (saves and recalls chord shapes - highly graphical and wonderful!)
I’m using SQLlite (actually realsql)
However, I’ve been trying to save colors and recall them.
I’m saving them to a varchar like this
&h004298F9

but

Notecolor(j)=rs.Field("Mnotecolor").stringvalue

(rs is a recordset. Notecolor(j) is a one dimensional array of color)
doesn’t work (it crashes).
The string contained in rs field is the color. How would I go about transferring the string “&h004298F9” into a color variable?
Cheers,
Sean

2

The quickest way is to push it into a variant and then extract the color value.

Dim v as variant = colorString Dim c as color = v.colorValue

3

You sir, are officially the bomb! :slight_smile:
Cheers, worked a treat!
Sea