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
1
vote
1 answer

How to reorder table columns in a SQLITE Database?

I have a table with two columns that I'd like to swap. I want the column with index 5 to be swapped with the column with index 4. This post from 2013 suggests this might not be possible. Is there a way to do this now? I am currently using SQLite…
artumi
  • 105
  • 8
1
vote
2 answers

Creating a date column with date format in SQL

I'm creating a table that contains a date registered column. I want it formatted as "YYYY-MM-DD". I've already attempted this... CREATE TABLE patient( dateregistered text format 'YYYY-MM-DD' not null ); Now, the problem I'm having is, when I…
mrteeth
  • 153
  • 1
  • 1
  • 8
1
vote
1 answer

How do I add data into a database using Sqlite manager

I want execute the insert query the query was working fine when we call this InsUpdateDelData its return false then the data was not inserted - (IBAction)addToCart:(id)sender { AppDelegate *obj = (AppDelegate *)[[UIApplication…
Ahmad Durrani
  • 93
  • 8
1
vote
1 answer

SQLite Manager INSERT INTO fails but produces no error

I have a SQLite DB that has a table: table: import_info Columns: First_Name, Last_Name, Payroll_ID, ... other columns not used tabel employees Columns: name, employee_num I want to select the unique names and payroll_id's from the first…
Beartech
  • 6,173
  • 1
  • 18
  • 41
1
vote
1 answer

Sqlite manager's icon doesn't appear

I have downloaded the Sqlite's jar file, placed it in the right folder and restarted eclipse but didn't find the icon that should have appeared. Where can I find it? The steps I was following.
Anis LOUNIS aka AnixPasBesoin
  • 4,765
  • 5
  • 32
  • 61
1
vote
1 answer

SQLite Manager Data Type

I'm using SQLite Manager Add-on, I couldn't find out the difference between these Data Types : 1) TEXT vs. TEXT (strict) 2) REAL vs. REAL (strict) 3) INTEGER vs. INTEGER (strict)
Barnabé
  • 11
  • 2
1
vote
1 answer

SQLite queries much slower using JDBC than in Firefox SqliteManager plugin

I'm having a problem with a query that I tested in the SQLiteManager plugin in Firefox. This particular query executes in about 60 ms in the Firefox plugin, but it takes a whopping 3.7 seconds to execute when I use the same query and the same…
Jumbala
  • 4,764
  • 9
  • 45
  • 65
1
vote
1 answer

cmd.ExecuteReader() with SQLite is slow but fast in SQLite Manager

I planned to use SQLite as local database. I created a complex Select statement with "group by" and "order by" in SQLite Manager (Firefox AddIn). The query run in about 600 ms in SQLite Manager. In my C# application i've created a SQLiteCommand…
Matti
  • 11
  • 4
1
vote
1 answer

SQL newbie: Use current date as variable in SQL query

I have used Excel and created 2 columns. column1 contains DATES, column2 contains values as INT. I have imported the table as a CSV using SQLite Manager. I am connected to the DB and have used it with success for other queries that involved text…
user1924697
  • 47
  • 1
  • 5
0
votes
1 answer

SQLITE ERROR IN iphone sdk (fmdb wrapper)

I have a problem in sqlite wrapper method.. i have defined the below functions and its showing error.. im not able to solve it. all im trying to do it swap rows in the database. it works fine in sqlite manager(firefox addon) with only sql statement.…
Sharanya K M
  • 1,805
  • 4
  • 23
  • 44
0
votes
1 answer

any support for UNDO in Sqlite manager

due to my impatience i corrupted my database with a replace query now all rows in that column shows 0. is there any support for Sqlite manager in Firefox using which i will be able to undo to my previous state of DB. Thanks
Shashank Degloorkar
  • 3,151
  • 4
  • 32
  • 50
0
votes
1 answer

Opening a c# sqlite-net-sqlcypher database in a SQLite manager and vice versa

Situation : Windows 11 - Latest updates; .NET 6 console app - latest updates; sqlite-net-sqlcypher nuget package (1.8.116) - also latest version; Both Visual Studio (2019 and 2022) and Rider - All latest versions) I have created a little test…
Geertie
  • 237
  • 4
  • 15
0
votes
1 answer

help needed with sqlite manager

hi i m using sqlite manager now the manager is showing me tables inside the database but when i m running my code it says that the table is not found. Here is my code. please can someone point out my mistake. - (IBAction)saveDatabase { …
Hadi
  • 1,212
  • 2
  • 17
  • 31
0
votes
0 answers

SQL Statement works in SQLiteManager, but not in my program

I am trying to take relevant values from an existing table and put them into a Virtual table, which I can then search through and get the entries I want. I have everything more or less working except the actual loading of the entries into this…
Samuel Ludwig
  • 111
  • 1
  • 7
0
votes
1 answer

FMDB error : No Such table

I created new DB in Documents using SQLite Manager. Created a table there too with a sample row. This code I am using for db path : +(ModelManager *) getInstance { if(!instance) { instance=[[ModelManager alloc]init]; …
Shivam Tripathi
  • 1,405
  • 3
  • 19
  • 37
1
2
3 4 5