Re: [sqlite] Query on Sqlite3 in an Android app

2012-02-09 Thread Lavanya Ramanan
message -- From: Roger Binns rog...@rogerbinns.com Date: Thu, Jan 26, 2012 at 12:47 PM Subject: Re: [sqlite] Query on Sqlite3 in an Android app To: sqlite-users@sqlite.org -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/01/12 09:15, Lavanya Ramanan wrote: I have created my

Re: [sqlite] Query on Sqlite3 in an Android app

2012-02-09 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/02/12 07:40, Lavanya Ramanan wrote: So I can use an excel/csv file as input to the content provider? Where do I place the file? You write the content provider code so it can do whatever you want. If you only need sequential read then it will

Re: [sqlite] Query on Sqlite3 in an Android app

2012-02-09 Thread Tim Streater
On 09 Feb 2012 at 15:40, Lavanya Ramanan lavanyacoo...@gmail.com wrote: And I would also like to know what GUI do people generally use for sqlite database. Navicat for SQLite Lite, although I rarely need to use it. Very occasionally I want to see the hex of some database column. -- Cheers

Re: [sqlite] Query on Sqlite3 in an Android app

2012-01-26 Thread Lavanya Ramanan
Thank you for your reply. I have created my own sqlite file from the command prompt. To access this database in an Android app, I should use content provider - is that what you are saying ? But I thought for using content provider, I create my own database using SQL statements in my Java code. So

Re: [sqlite] Query on Sqlite3 in an Android app

2012-01-26 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/01/12 09:15, Lavanya Ramanan wrote: I have created my own sqlite file from the command prompt. To access this database in an Android app, I should use content provider - is that what you are saying ? No. What I am saying is that if you are

[sqlite] Query on Sqlite3 in an Android app

2012-01-25 Thread Lavanya Ramanan
Hello, I am new to Java and Android. I am trying to build an android application which could access my own sqlite.db file. For using my own sqlite database in an android app, I followed the code given in

Re: [sqlite] Query on Sqlite3 in an Android app

2012-01-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/01/12 14:31, Lavanya Ramanan wrote: What am i missing? The SQLite Java wrapper in Android automatically creates the directory when you use it to create a database. Since you are bypassing that you'll need to create the directory yourself