Stack Overflow
Stack Overflow

Questions tagged [sqlitemanager]

SQLiteManager is a multilingual web based tool to manage SQLite database. Use this tag for questions related to the relational database management system.

SQLiteManager is a multilingual web based tool to manage SQLite database. Use this tag for questions related to the relational database management system.

69 questions
0
votes
0 answers

SQLite Manager: how to select columns in a table, keeping the count of the original occurrence of their values?

I am new to databases, and I am using the SQLite Manager Firefox add-on for a table like this: rowid | col1 | col2 | col3 1 | N | Y | N 2 | N | N | N 3 | N | Y | Y 4 | N …
Giulia
  • 205
  • 1
  • 2
  • 5
0
votes
2 answers

Connect existing SQLite database android project in Eclipse

I created an android project in Android Eclipse and I want to connect to the database I've created in SQLite Manager. The database will be saved locally. It is basically a read only only app, there are no create delete update actions done by the…
userC22
  • 31
  • 1
  • 10
0
votes
1 answer

Is SQLite Manager refreshing itself properly?

I added new rows to my database through SQLiteManager but I cannot see those values in my tableview. My old values are seen. More interestingly, I deleted my database file but I can see my old values again in my tableview. When I created new…
user310000
  • 105
  • 2
  • 9
0
votes
0 answers

java.sql.SQLException: No such table : Member_Registration

I am using Netbeans IDE and Sqlite add on from firefox. Only when I use Login table code successfully run but while I trying to use another tables "No such table " error is coming . I didn't get what is going on? Whether there is any error in my…
Shruti
  • 391
  • 1
  • 5
  • 21
0
votes
1 answer

transactional renaming database files .db and db-journal plus database sharing

I want to rename database files. The tasks seems to be easy. 1) I close database 2) rename .db file 3) rename .db-journal file 4) I open database However what will happen if ex. after the step number 2 and before the step number 3 the system will…
user2707175
  • 1,133
  • 2
  • 17
  • 44
0
votes
1 answer

Sqlite manager couldn't open my android database

When I try to open my database file with sqlite database it shows me the following errors: [2014-05-19 23:50:51] Failed to open database file db_penpal.db [2014-05-19 23:50:51] null Does that mean that my database contains some bugs? If yes, how…
Anis LOUNIS aka AnixPasBesoin
  • 4,765
  • 5
  • 32
  • 61
0
votes
1 answer

SQLite CREATE TABLE [ near "": syntax error ]

i have a problem with the following SQL command using SQLite Manager: CREATE TABLE "types" ("id" INTEGER PRIMARY KEY, "name" TEXT, "kind" TEXT, "length" INTEGER); It generates the following syntax error: SQLiteManager: CREATE TABLE "types" ("id"…
maggie
  • 3,935
  • 3
  • 27
  • 31
0
votes
3 answers

ERRO null with sqlite and java

I am developing java application in netbeans. I connected database sqlite and it works perfectly. Now, i am trying to delete a field in database: public void delete(){ dbo.openConnection(); String sqlCommand = "DELETE FROM restaurante WHERE…
apolo90
  • 57
  • 1
  • 9
0
votes
1 answer

How to create a composite primary key using SQLite Manager

For a project I'm working on one of my SQLite tables requires a composite primary key consisting of two foreign keys. The record retrieval relies on two conditions; a college course and the students that are enrolled onto that course. I cant see…
user2211830
  • 1
0
votes
1 answer

SQLiteManger panel in MAMP Pro gives me blank page

I've recently began looking at administrating SQLite databases through a GUI and would like to try out SQLite Manager which comes bundled with MAMP Pro, however trying to access the tool from its panel (through "Webstart") gives me a blank page. I…
Staffan Estberg
  • 6,795
  • 16
  • 71
  • 107
0
votes
1 answer

SQLITE manager on a server

I was wondering if it was possible to get an SQLITE manager database onto a server? What i mean by this is so that when i complete my program in a java project and make an installer for that project. Anyone who downloads it from any computer running…
user1992697
  • 315
  • 1
  • 5
  • 11
0
votes
1 answer

SQLite manager, Add on to FireFox

I'm new to databases and i need to use it for a project i am working on, i have the following question. If we use SQLite manager to create a database on java and then produce a jar file of the complete program. To install this project do we have to…
user1957939
  • 1
  • 1
0
votes
1 answer

datetime() in SQLite Manager

I cannot seem to figure out why datetime does not work for me on some data I imported from CSV. I have a column, TIMESTAMP, which is of type datetime. Select TIMESTAMP from GPS limit 1 <-This gives me a time, "6/29/2009 00:00:00" Select…
David Manheim
  • 2,553
  • 2
  • 27
  • 42
0
votes
2 answers

What is wrong with this simple java code to access SQLite database in Android?

I created a database file (.db) with one table TEstTable using SQLiteManager and pasted it in /assets folder. I want to perform actions on this database from my Android Application. In order to do so I followed this tutorial as recommended on Stack…
Ayush Goyal
  • 2,079
  • 8
  • 32
  • 47
0
votes
1 answer

How to access SQLite Database created in SQLiteManager in Android App?

I have a database created in SQLiteManager from Mozilla, I exported it and saved the .sql file in assets folder, now how do I read or make entries in this database from my android app? How should my DatabaseHandler( which extends SQLiteOpenHelper)…
Ayush Goyal
  • 2,079
  • 8
  • 32
  • 47
1 2 3
4
5