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

Failed to find database file from ddms folder while running app in emulator using Realm

Trying to find database file from Tools ---> Android Device Monitor but its giving me error: While i already defined path for JAVA_HOME environment variable and path as well. JDK is installed in path: C:\Program Files\Java\jdk1.8.0_151\bin But…
Erum
  • 790
  • 3
  • 14
  • 36
0
votes
1 answer

SQLite: Table alias not found when trying to create a new table from a join of two select statements

I hope the title makes sense, I'm fairly new to writing queries and am shaky on the terms and such. I'd like some help understanding why my table alias isn't found on the following query. When I run it without the ON clause it executes (on SQLite…
Andy
  • 281
  • 2
  • 7
  • 23
0
votes
1 answer

Cannot put a date as a default value in sqlite manager

I have a DATETIME column. I want the default to be 1970-01-01 00:00:00 When I enter that as the value, sqliemanager complains that it isn't valid - something about the dash? But sqlite date data always has dashes. What exactly is the value I put in…
bharal
  • 15,461
  • 36
  • 117
  • 195
0
votes
1 answer

data could not be fetched when selected from sqlite database

data could not be fetched when selected from sqlite database , and showing error of [NSPlaceholderString initWithUTF8String:]: NULL cString' , at step function . ... i am mentioning all the steps which i have followed to perform this operation . so…
Moxarth
  • 303
  • 4
  • 13
0
votes
1 answer

Missing list of tables in Sqlite Manager Firefox Add-on

With the Sqlite Manager Add-on in Firefox. On the left, there has always been a list of the tables that are in the currently opened database. I must have closed something, because it's not there anymore... and I can't figure out how to reopen it...…
Brian Rice
  • 3,107
  • 1
  • 35
  • 53
0
votes
1 answer

double quotes in view name

I'm trying to create a view in sqlite that contains double quotes (I'm using the SQlite Manager Addon in Firefox). According to the escape rules (doubling double quotes) the following statement should work CREATE VIEW "Name with ""quotes""" AS…
user3210625
  • 163
  • 3
  • 13
0
votes
1 answer

SQLite Manager not correctly generating query

This is my query and associative variables: public static final String DATABASE_NAME = "HDL_db"; public static final String TABLE_NAME = "HDL_table"; public static final String COL_3 = "Arrival_Time"; public static final int database_version =…
Tom Dunwoody
  • 9
  • 4
0
votes
1 answer

Is it possible to change a column without run raw sql in DbVisualizer + SQLite

Working on a SQLite database, seems DbVisualizer Pro does a lot of work very well, except one, Changing table schema. I often need to change column name, data type, etc, but don't want to do it through raw SQL statement. My workaround is opening…
Rm558
  • 4,621
  • 3
  • 38
  • 43
0
votes
2 answers

insert data from table into another table if don't exist

hi so that's my problem :(i'm working in eclipse with java ) i have this table phone(id,mark,reference,OS) and i have 3 seller vend1,vend2,vend3(id,mark,reference,os,price) i want insert all data from vend1 and vend2 and vend3 into the table phone…
Chika Loka
  • 3
  • 1
0
votes
1 answer

swift2 : Path of image in sqlite manager not showing up on iphone device

This path I keep in database in sqlite manager /Users/james/Desktop/Travel/orginal image/TEE5883m.jpg When I run in simulator, It works fine, But in iphone device is not show image. I don't know why, help me please.
Dos
  • 3
  • 4
0
votes
1 answer

Core data prefilling sqlite db. What is Z_MAX?

I am using the SQLite Manager extension to Firefox to prefill my core data sqlite database. But when i try adding more to the prefilled database my app crashes. I suspect it has something to do with Z_MAX for my entity in the table…
LarsJK
  • 2,196
  • 18
  • 23
0
votes
1 answer

I cant see my database in Android Studio File Manager

I have been following a tutorial line by line, and I cant seem to find my database in the /data/data/com.package.www/databases/. It is filled with con folders. There are no errors whatsoever while debugging. Thank you.
ayushboss
  • 19
  • 1
  • 5
0
votes
0 answers

Suspicious data changes when updating SQLite database [Android]

I am following this AlarmClock tutorial (project .zip also available on GitHub) on how to build my alarm for Android. I fixed some code that was bad, etc, but it still doesn't work as it should. I've been getting a lot of SQLiteDatabase leaks and I…
Vekszor
  • 1
0
votes
1 answer

connect to sql server to sqlite in sqlite manager

how do I import a sql query into a sqlite database? I'm using the sqlite manager add on in firefox, and there is an option to import SQL, but I don't see where I can connect to a server. I'm looking for some code in this format: BEGIN…
md1630
  • 841
  • 1
  • 10
  • 28
0
votes
2 answers

SQLite Manager (Firefox) does not do UPDATE statement on multiple rows

I'm confused on how I seem to fail at doing a simple update in SQLite. I've installed SQLite Manager in Firefox and I want to update the moz_places table there because we recently changed 'provider' and instead of clearing my whole history in…
deroby
  • 5,902
  • 2
  • 19
  • 33
1 2
3
4 5