Recent questions tagged sqlite

0 votes

786 views

1 answer

sqlite - How to display blob value using x'abc' binary string literal syntax?

You can easily enter a blob value using the x'abc' syntax, but is there a way to display it ... x'0123456789abcdef0123456789abcdef' Thanks, --DD See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

509 views

1 answer

sqlite - Integration Testing Entity Framework code first with in-memory database

I'd like to run actual integration tests of my EF4.1 repositories against an in-memory database a la ayende ... .GetAll<Audit>(); } See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

621 views

1 answer

sqlite get ROWID

consider this simple table(tbl1): A|first letter B|second letter C|third letter first column is letter and second ... ROWID of the result row? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

454 views

1 answer

sqlite - How to test an iPhone application update?

I already have an iPhone application (version 1.0) available in the App Store and am ready to submit ... when developing an application update? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

550 views

1 answer

sqlite - New Line character not displaying properly in textView Android

I know that if you do something like myTextView.setText("This is on first line This is on second line"); ... in the database. Any suggestions? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

797 views

1 answer

sqlite - Android Delete Query

I'm attempting to delete all rows in one table that do not have a corresponding ID in another table. Since ... FROM my_table2)"}); Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

677 views

1 answer

sqlite - Database handling stopped working on Android 2.2.1 (Desire HD 1.72.405.3)

For some reason the database handling solution described in this article doesn't work on the HTC Desire HD after it ... is line 10 at pastebin. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

701 views

1 answer

sqlite - SQL - Inserting a row and returning primary key

I have inserted a row with some data in a table where a primary key is present. How would one "SELECT" the ... that I'm currently using SQLite. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

634 views

1 answer

sqlite - How to get the number of rows of the selected result from sqlite3?

I want to get the number of selected rows as well as the selected data. At the present I have to use two ... this problem? Thank you very much! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

658 views

1 answer

sqlite - Android Device Monitor "data" folder is empty

I have tested creating, inserting and retrieving data into my apps db, and know it works through usage of Log ... the db file and contents? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

676 views

1 answer

sqlite - Modify a Column's Type in sqlite3

I'm pretty new to SQLite 3 and just now I had to add a column to an existing table I had. I went about ... my wording being off in the query. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

594 views

1 answer

sqlite - How to check database on not rooted android device

I am developing an app where i am using sqllite3 database to store values. I have Nexus S and Nexus 7 both are ... , then quit... sqlite> .exit See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

665 views

1 answer

sqlite - script to convert mysql dump sql file into format that can be imported into sqlite3 db

I have an export SQL file containing tables and data from MySQL and I want to import it into a Sqlite 3 DB. ... the sqlite3 tool doesn't work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

844 views

1 answer

sqlite - How to get INSERT OR IGNORE to work

I'm trying to insert data into a table. I would like to insert the row if the column doesn't have the data ... this is just a simple test case. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

663 views

1 answer

sqlite - How to get a list of column names

Is it possible to get a row with all column names of a table like this? |id|foo|bar|age|street|address| ... like to use Pragma table_info(bla). See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

592 views

1 answer

sqlite - Python sqlite3 and concurrency

I have a Python program that uses the "threading" module. Once every second, my program starts a new thread ... possible with sqlite. Any ideas? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

628 views

1 answer

sqlite - Android: column '_id' does not exist

I am getting this error IllegalArgumentException: column '_id' does not exist When using a SimpleCursorAdapter to ... help solve the problem? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

859 views

1 answer

sqlite - Ruby: SQLite3::BusyException: database is locked:

Ran into this error message whilst developing tonight: SQLite3::BusyException: database is locked: I have two models: ... if it's gonna help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

585 views

1 answer

sqlite - Bulk Insertion on Android device

I want to bulk insert about 700 records into the Android database on my next upgrade. What's the most efficient ... Are 3 and 4 even possible? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

sqlite - Auto Increment on Composite Primary Key - Sqlite3 + Python

I have a code like this c.execute('CREATE TABLE IF NOT EXISTS base (ID INTEGER NOT NULL, col2 TEXT NOT NULL, col3 ... . What can I do? Any idea? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

404 views

1 answer

sqlite - Is it possible to apply primary key on the text fields in android database

I have created a simple table that contains the name and email id's of the persons. When i am giving the create query ... rowId, null) > 0; } } See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

sqlite - SQLITE3 VACUUM, "database or disk is full"

I'm trying to run the VACUUM command on my database, but I seem to run out of space: > sqlite3 mydatabase. ... allow the vacuum command to run? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

530 views

1 answer

sqlite - How can I open a database already created in flutter and show its data?

I am new to flutter and have come across a question in flutter. 1 . I already have a Database created in SQLITE. 2 ... NULL I attached the image https://i.stack.imgur.com/VKWbJ.png...

asked Jan 29, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

665 views

1 answer

sqlite - How can I open a database already created in flutter and show its data?

I am new to flutter and have come across a question in flutter. 1 . I already have a Database created in SQLITE. 2 ... NULL I attached the image https://i.stack.imgur.com/VKWbJ.png...

asked Jan 29, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags