I created a database with a DB Browser for SQLite and then imported it to Xojo. Now I’m little confused, because Xojo shows different data types which I defined in SQLite browser. Here is screenshots of both programs. So the question. Does it matter if Xojo shows different types?
Now i found solution. I copied it to build settings files and select resource folder and now it is where i want it to be. I programming as my hobby and when you to do it every know and you could forget something. Especially when i have recently developed to iOS and now trying to develope desktop.
Thank you for your help. This forum is very fast to respond.
You can create a window (or a specific project) that display your (all) SQLite Data Base contents too.
All you have to do is to follow the nstructions / provided examples to display the TABLES, and TABLE contents.
Once you have the list of available TABLES (dsplayed n asnge Column ListBox), you can display the Tables contents in another ListBox and so you will know what you wrote in your .sqlite file.
You then learn a lot and no more need a specialized software to know what you’ve done.
You are right, it doesn’t work, but this does. You can learn some finnish.
App.DB = New SQLiteDatabase
App.DB.DatabaseFile = New FolderItem(“kulutusseuranta.sqlite”)
Try
If App.DB.Connect Then
EtusivuWindow.TulosField.Text = “Tietokantayhteys”
End If
Catch e as DatabaseException
MessageBox("Ei onnistunut. Virhe: " + e.Message)
Return
End try