Hi.
I'm running FreeBasic 1.07 on Ubuntu 20.04
I want to be able to access sqlite3 databases.
Questions:
1. I installed sqlite3, but when I request the version number, I get:
sqlite3 -version
-- Loading resources from /home/mg/.sqliterc
Error: near line 4: near "*": syntax error
3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1
What to do here?
2. What FreeBasic command would I use to establish an sqlite connection with a database?
Thanks,
M....
Ubuntu FreeBasic & SQLite3
-
- Posts: 17
- Joined: Jan 05, 2021 20:43
- Location: 1000 Islands, Ontario, Canada
Re: Ubuntu FreeBasic & SQLite3
This is the version number.
Not sure what is up with the error, but if you look up running the command for version, it shows a message just like the one above.Mike Green9 wrote: 3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1
Re: Ubuntu FreeBasic & SQLite3
I have no experience with sqlite, but what is at line 4 in your .sqliterc? Did you check? (note: hidden file)Mike Green9 wrote: 1. I installed sqlite3, but when I request the version number, I get:
sqlite3 -version
-- Loading resources from /home/mg/.sqliterc
Error: near line 4: near "*": syntax error
3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1
What to do here?
From what I read here (https://stackoverflow.com/questions/417 ... m-sqliterc), you could try to rename .sqliterc.
At my system with sqlite 3.22.0 installed, I do not have a .sqliterc file.
Did you check the example shipped with freebasic: https://github.com/freebasic/fbc/blob/m ... 3_test.basMike Green9 wrote: 2. What FreeBasic command would I use to establish an sqlite connection with a database?
-
- Posts: 17
- Joined: Jan 05, 2021 20:43
- Location: 1000 Islands, Ontario, Canada
Re: Ubuntu FreeBasic & SQLite3
Re sqlite3 -version giving an error.
Silly mistake on my part. I added a comment line to /home/mg/.sqliterc with a leading * instead if /*.
My bad.
Re sqlite3 & FreeBasic
I'm looking into the example shipped with freebasic: https://github.com/freebasic/fbc/blob/m ... 3_test.bas.
GREAT help!
Thanks,
M...
Silly mistake on my part. I added a comment line to /home/mg/.sqliterc with a leading * instead if /*.
My bad.
Re sqlite3 & FreeBasic
I'm looking into the example shipped with freebasic: https://github.com/freebasic/fbc/blob/m ... 3_test.bas.
GREAT help!
Thanks,
M...