Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
I have column (named Cost) in database, with 3 letters A,B and C. I would like to replace these letters so that the colour is displayed instead the letters themselves. How to approach this?
Here is visual example. There are two columns named Cost, ignore the one that shows the letters A, B, C. This is just to show data I currently have. I would like it to display as on the right side (column Cost), where you see 3 set of different colours.
Thanks.
I don't get it from the comments above how to insert existing database SQLite into my *.vdb project.
How can I import existing SQLite database? I have converted my csv file via RSQLite library using software R and saved the database as mydb.sqlite, all I see in the intro videos is how to create/insert data table. But I have already database table.
So if this is not the way to go you mention in other post that other way to imprt csv file is to use SQLite studio. I have successfully loaded mydb.sqlite into the SQLite studio so how to proceed next? Do you have any source/material available or a tutorial to use?
Thanks.
Posts found: 3