Is there any way to describe our tables in sqllite.?

You must Login before you can answer or comment on any questions.

Hai guys iam using titanium with sqlite but iam facing problem with sqlite i don't know how to describe my tables in sqlite?plz help me any one,and also give any proper link for sqlite with titanium.

3 Answers

Accepted Answer

— answered 1 year ago by Mitul Bhalia
answer permalink
8 Comments
  • already i saw that,but i want where is location of created database,and how to describe the tables in database thanku for quick responce

    — commented 1 year ago by pradeep kondapaka

  • for ios you can find it in

    iphone simulator folder -> <ios verison> - >Applications -> <app id> ->Library->Private Document
    for android you can use ddms tool. this can be found in you android sdk's folder after opening this ddms tool select emulator from left window then select Device from menubar and select fileExplorer. so it will open a new window with that select
    data->data-> <package name> -> databases

    — commented 1 year ago by Mitul Bhalia

  • C:\Users\ensis\sdk\tools\lib here i found ddms file but it is not opening,it is a executable jar file

    — commented 1 year ago by pradeep kondapaka

  • Show 5 more comments

Hi Here is a very helpful tutorial with step by step understanding.I am using it to make quiz app.

http://mobile.tutsplus.com/tutorials/appcelerator/titanium-mobile-database-driven-tables-with-sqlite/

For Creating Table : CREATE TABLE IF NOT EXISTS table1 (field1 TEXT, field2 TEXT,field3 TEXT,field4 TEXT) For Inserting Record Table : insert into table1(field1, field2, field3, field4) values (?,?,?,?,?)', field1,field2, field3, field4

Your Answer

Think you can help? Login to answer this question!