sqlite Archives - Page 4 of 5

How to use an existing database with an Android application [duplicate]

This question already has answers here: Ship an application with a database (15 answers) Closed 9 years ago. I have already created an ...

May 13, 2022
0 Comments

Java and SQLite [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question ...

May 13, 2022
0 Comments

Store boolean value in SQLite

What is the type for a BOOL value in SQLite? I want to store in my table TRUE/FALSE values. I could create a ...

May 13, 2022
0 Comments

How to set Sqlite3 to be case insensitive when string comparing?

I want to select records from sqlite3 database by string matching. But if I use ‘=’ in the where clause, I found that ...

May 12, 2022
0 Comments

How to get Top 5 records in SqLite?

I have tried this which did not work. select top 5 * from...

May 12, 2022
0 Comments

What are the performance characteristics of sqlite with very large database files? [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

May 11, 2022
0 Comments

Insert new column into table in sqlite?

I have a table with columns name, qty, rate. Now I need to add a new column COLNew in between the name and ...

May 8, 2022
0 Comments

Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?

I’m just getting started learning SQLite. It would be nice to be able to see the details for a table, like MySQL’s DESCRIBE ...

May 4, 2022
0 Comments

How to get a list of column names on Sqlite3 database?

I want to migrate my iPhone app to a new database version. Since I don’t have some version saved, I need to check ...

May 3, 2022
0 Comments

What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?

I have a project in which I’d like to use some of the .NET 4.0 features but a core requirement is that I ...

May 2, 2022
0 Comments