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

hi,

working with sqlite database

— answered 6 months 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 6 months 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 6 months 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 6 months 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!