When I try to run the '.tables' command by doing the following:
SQLiteDatabase db = this.openOrCreateDatabase(DB_NAME, MODE_PRIVATE,
null);
db.execSQL(".tables");
I get this error:
ERROR/Database(13071): Failure 1 (near ".": syntax error) on 0x1f3f60
when preparing '.tables'.
On Dec 1, 8:14 am, sathya subbiah <sathya.subbia...@gmail.com> wrote:
> Hi,
>
> Use
> execSQL<http://developer.android.com/reference/android/database/sqlite/SQLite...>provided
> by Android for executing SQL commands.
>
>
>
> On Tue, Dec 1, 2009 at 7:50 AM, dsukhram <duanesukh...@gmail.com> wrote:
> > Thanks for your reply. But I have looked at this class and I only see
> > methods for creating,deleting or executing queries on a database. I
> > don't see any methods for issuing a sqlite command. Maybe i'm blind
> > but can you point out a method in this class that i would use?
>
> > thanks
>
> > On Nov 30, 4:04 pm, Dianne Hackborn <hack...@android.com> wrote:
> > >http://developer.android.com/reference/android/database/sqlite/SQLite..
> > .,
> > > java.lang.Object[])
>
> > > On Mon, Nov 30, 2009 at 12:37 PM, dsukhram <duanesukh...@gmail.com>
> > wrote:
> > > > Well thats the question i'm asking. I've looked at a various classes
> > > > under the android.database.sqlite package but I can't seem to find one
> > > > to do what I want. Can you tell me which one I need to use?
> > > > On Nov 30, 2:57 pm, Dianne Hackborn <hack...@android.com> wrote:
> > > > > Why would you want to do that? Use the SQLite APIs to execute
> > whatever
> > > > > operations you want on the database.
>
> > > > > On Mon, Nov 30, 2009 at 11:49 AM, dsukhram <duanesukh...@gmail.com>
> > > > wrote:
> > > > > > When my app loads up I need to import a bunch of records into its
> > > > > > database.
>
> > > > > > How do I run the following sqlite3 command from my app?
>
> > > > > > sqlite3>.read /data/data/<app>/files/records.sql
>
> > > > > > --
> > > > > > You received this message because you are subscribed to the Google
> > > > > > Groups "Android Developers" group.
> > > > > > To post to this group, send email to
> > > > android-developers@googlegroups.com
> > > > > > To unsubscribe from this group, send email to
> > > > > > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com>
> > <android-developers%2bunsubscr...@googlegroups.com<android-developers%252bunsubscr...@googlegroups.com>
>
> > > > <android-developers%2bunsubscr...@googlegroups.com>
> > > > > > For more options, visit this group at
> > > > > >http://groups.google.com/group/android-developers?hl=en
>
> > > > > --
> > > > > Dianne Hackborn
> > > > > Android framework engineer
> > > > > hack...@android.com
>
> > > > > Note: please don't send private questions to me, as I don't have time
> > to
> > > > > provide private support, and so won't reply to such e-mails. All
> > such
> > > > > questions should be posted on public forums, where I and others can
> > see
> > > > and
> > > > > answer them.- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > --
> > > > You received this message because you are subscribed to the Google
> > > > Groups "Android Developers" group.
> > > > To post to this group, send email to
> > android-developers@googlegroups.com
> > > > To unsubscribe from this group, send email to
> > > > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com>
> > <android-developers%2bunsubscr...@googlegroups.com<android-developers%252bunsubscr...@googlegroups.com>
>
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/android-developers?hl=en
>
> > > --
> > > Dianne Hackborn
> > > Android framework engineer
> > > hack...@android.com
>
> > > Note: please don't send private questions to me, as I don't have time to
> > > provide private support, and so won't reply to such e-mails. All such
> > > questions should be posted on public forums, where I and others can see
> > and
> > > answer them.
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Android Developers" group.
> > To post to this group, send email to android-developers@googlegroups.com
> > To unsubscribe from this group, send email to
> > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com>
> > For more options, visit this group at
> >http://groups.google.com/group/android-developers?hl=en- Hide quoted text -
>
> - Show quoted text -
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
