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

2012-02-09 Thread Tim Streater
On 09 Feb 2012 at 15:40, Lavanya Ramanan 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. --

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

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

2012-02-09 Thread Lavanya Ramanan
;wrote: > > > -- Forwarded 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

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

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-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

[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