Questions tagged [sqlite2]
24 questions
1
vote
4 answers
How do I add a column in a sqlite 2 database table
How do I add an additional column to an existing sqlite 2 database table that have data and indexes associated with it.
It seems like the alter table SQL for that is not available in sqlite2?
Hannes de Jager
- 2,903
- 6
- 37
- 57
0
votes
1 answer
Missing localforage.js files when installing localforage-cordovasqlitedriver into my project
I am trying to get localforage-cordovasqlitedriver presented within my IOS/IONIC/Cordova project so that I can access it and change all my localstorge.setitem(key,value) and localstorge.getitem(key,value) commands to localforage.setitem(key,value)…
ACE
- 33
- 6
0
votes
1 answer
Removing orphans (SQLite 2) in dtree
I have SQLite 2 table:
Columns:
id, parent_id, value
1,0,'TOP FIRST' <---- top category "FIRST"
2,1,'11111-A' <----subcategory of id 1 (FIRST)
3,1,'11111-B' <----subcategory of id 1
4,0,'TOP TWO' <---- top category "TWO"
5,4,'22222-A' …
pw_1
- 1
- 1
0
votes
2 answers
How to make a database service in Netbeans 6.5 to connect to SQLite databases?
I use Netbeans IDE (6.5) and I have a SQLite 2.x database. I installed a JDBC SQLite driver from zentus.com and added a new driver in Nebeans services panel. Then tried to connect to my database file from Services > Databases using this URL for my…
farzad
- 8,775
- 6
- 32
- 41
0
votes
2 answers
How to check if sqlite2 is installed?
How can I check if sqlite2 is installed? Is it relatively easy?
Is it as simple as a 1 line check?
Jamesking56
- 3,683
- 5
- 30
- 61
0
votes
0 answers
sqlite2 autoincrement error
I have a problem with sqlite2 (not sqlite3, because I use php).
I tried to create a table with the following query:
CREATE TABLE Messaggi (id INTEGER PRIMARY KEY AUTOINCREMENT,content TEXT, date DATETIME DEFAULT (date('now')), owner TEXT, viewed…
donadev
- 439
- 2
- 7
- 17
0
votes
2 answers
Share sqlite2 database with Yii webapp
Hi I've got a sqlite2 database that is being used by a PHP webapp and I want a Yii webapp to access it. At the moment I copied the db file to a local server and I've changed config/main.php to:
'db'=>array(
'connectionString' =>…
Luke Wenke
- 1,149
- 2
- 23
- 43
0
votes
1 answer
Exporting sqlite2 database to SQL
Hi I'd like to export data from a sqlite2 database into SQL to import into phpMyAdmin. Thanks.
Luke Wenke
- 1,149
- 2
- 23
- 43
-2
votes
2 answers
SQLite transaction on power failure or system crash
I have a running C program that updates an SQLite record's description and I want it to be transactional that's why there is BEGIN and COMMIT statements before and after the UPDATE statement is executed. I'm not sure if this is already sufficient if…
ordinary_guy
- 11
- 6