you should use .tables to view the tables in the db.............

On 1/13/09, jayesh.thadani <jayesh.thad...@gmail.com> wrote:
>
>
> Hi pratap,
> yes i created table in program...
> and it is working fine, i am able to retrieve data from table, my
> problem is .table in sqlite3 is not showing tables that are in
> database
>
> Same problem is with notepad1,2 & 3 application which is given as a
> sample application..
>
> In sample example, database and tables in it exist... but .table in
> sqlite3 is not viewable...
>
>
>
> On Jan 13, 3:18 pm, PRATAP SOLAPUR <pratap.sola...@gmail.com> wrote:
> > have u created the table in the command mode or in program............i
> > think the table has not been  created........
> >
> > Use .schema with no arguements, it'll list all the tables.......
> >
> > On 1/13/09, jayesh.thadani <jayesh.thad...@gmail.com> wrote:
> >
> >
> >
> > > Hi..
> > > I am using sdk1.0
> >
> > > i created database as firstDB & created table in it as firsttable
> >
> > > my application is working fine, but am not been able to view tables
> > > name in database.
> >
> > > i open it with sqlite, it shows database name in it with .databases
> > > command..
> >
> > > but when i used .table it does not show tables contained in that
> > > database..
> >
> > > Please help me out. i watch previous forum , i think there is problem
> > > with permission settings..
> >
> > > Thanks,
> >
>

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

Reply via email to