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
41
votes
4 answers

SQLite - alter a table's column type?

I am starting a project involving a small database and I am considering to use SQLite. If I create a table and I defined one of the columns as text, but all the values stored are integers - is there a way to change the data type of a column? I am…
Nick_F
  • 1,103
  • 2
  • 13
  • 30
37
votes
1 answer

Foreign Key constraint doesn't work

I have two tables, theme and quiz, here is their definition: CREATE TABLE "theme" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "nom" VARCHAR NOT NULL ); CREATE TABLE quiz( id INTEGER PRIMARY KEY, nom …
Luca
  • 20,399
  • 18
  • 49
  • 70
6
votes
3 answers

DROP Syntax error in SQLiteManager

I have downloaded sqlite manager app in Firefox browser and open sqlite manager app. 1) Created database named DBSQLTEST. 2) Created table named SQLTEST contain has threes fields are SLNO, NAME and AGE 3) Inserted new records But i want remove a…
Taj rajan
  • 601
  • 1
  • 6
  • 20
5
votes
4 answers

Run multiple commands in sqlite manager

It's possible to run more than one command in the direct SQL execution in SQlite Manager? (useful if you insert a lot of data) e.g. insert into TestTable (Name, Age) values("Thomas", 25) insert into TestTable (Name, Age) values("Peter", 29) ... Thx
leon22
  • 5,280
  • 19
  • 62
  • 100
5
votes
0 answers

How to launch the sqlite manager (firefox add-on) directly without launching the firefox first?

I recently switched over to Chrome from my old favorite Firefox for browsing, but use the SQLite manager very often. Just trying to see if I can avoid opening and closing of the empty firefox windoow everytime I use the sqlite manager. Don't think…
Venkat Reddy
  • 91
  • 3
  • 7
3
votes
1 answer

How can I open a SQLite database in android?

If I created a database using another application not through android runtime, let's say using 'SQLite Manager'(firefox extention), how can I then use that database (the .Sqlite file that is generated) in my android application? Since the SQLite is…
Q8Y
  • 3,801
  • 12
  • 39
  • 38
3
votes
3 answers

Syntax Error in Sqlite manager

hi I m using the following code to generate a table on sqlite manager. CREATE TABLE Transaction (ID PRIMARY KEY , amount REAL , currencyCode CHAR(3) , comments VARCHAR , debitAccount INTEGER , creditAccount INTEGER , debitAccountExchangeRate REAL ,…
Hadi
  • 1,212
  • 2
  • 17
  • 31
2
votes
2 answers

Indexing SQLite database: Empty Index ?

I have a .sqlite db which contains only one table. That table contains three columns and I am interested in indexing one column ONLY. The problem is, when I perform the indexing, I got an empty index table ! I am using SQLite Manager add-ons for…
iTurki
  • 16,292
  • 20
  • 87
  • 132
2
votes
2 answers

SQLite Foreign keys not working correctly

The following is a query for creating a table: CREATE TABLE "FacilityRating"( "FacilityRatingId" INTEGER PRIMARY KEY NOT NULL, "Stars" VARCHAR, "Facility_FacilityId" INTEGER, "User_UserId" INTEGER, FOREIGN KEY…
Bugs Happen
  • 2,169
  • 4
  • 33
  • 59
2
votes
2 answers

SQLite Manager - Copy table to another .sqlite database

Working on my first iOS App with SQLite database. In Project I have 2 Database, in which First Database is having only one table and the another one is working as a main database. I want to merge those databases into one (the Second one), by copy…
viral
  • 4,168
  • 5
  • 43
  • 68
2
votes
4 answers

How to use XULRunner to run SQLite Manager outside of Firefox in Mac OS X Lion?

I have installed XULRunner 11.0 (xr) from here: Downloads - sqlite-manager - Extension for Firefox and other apps to manage any sqlite database - Google Project Hosting I have followed the steps listed here: kiveo - Mac SQLite Manager Standalone…
leanne
  • 7,940
  • 48
  • 77
1
vote
1 answer

My Update statement is not working

I tried to update an entry in my table like this: NSFileManager *fileMgr=[NSFileManager defaultManager]; NSString *dbPath=[[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"quizDB.sqlite"]; if ([fileMgr…
Luca
  • 20,399
  • 18
  • 49
  • 70
1
vote
1 answer

Adding data to SQLite3 DB from within Xcode

I am trying to add 3 pieces of data to a SQLite3 DB. With help from a tutorial, I'm almost there. Below is my code. I am receiving what I would expect from the NSLogs. I find the DB without problem, I compile the statement to send to the DB without…
Solid I
  • 580
  • 5
  • 13
  • 34
1
vote
1 answer

Store UUID in sqlite manager

I am a newbie here. I am trying to generate UUIDs using the following code.. - (NSString *)GetUUID { CFUUIDRef theUUID = CFUUIDCreate(NULL); CFStringRef string = CFUUIDCreateString(NULL, theUUID); //CFUUIDBytes number =…
Hadi
  • 1,212
  • 2
  • 17
  • 31
1
vote
1 answer

Why is my SQLite database bloated to 12MB (from 280KB) with single quotes?

I'm using SQLiteManager. I had a 280KB database that bloated to over 12MB in just one day. I wasn't doing anything atypical. I still only have about 4-6 light results in the entire database. When I open up the database file with a text editor, I…
execution
  • 11
  • 1
  • 1
1
2 3 4 5