WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?

[rsu333]

i want to use/run database sslite [or any]  in lamw  app [run all related properties  ] for  that
purpose which is best demo or example I use ? 

[jmpessoa]

What AppSqliteDemo1 (and AppSqliteDemo2, ...., etc)?

[rsu333]

Thanks JM.

I have refered stated demo examples but I have still few problems [ as I am beginner] kindly guide me accordingly
1]Which components are require to  add or load records from  squile table into grid or dblist or list/view
 2]How can we load [ or read -edit ]         records from  database table ?
 Thanks once again .

[jmpessoa]

Well, if already learned  AppSqliteDemo1 (and AppSqliteDemo2, ...., etc) then you can try:


"AppDBGridViewDemo1"

[rsu333]

OK, thanks

[rsu333]

Thanks once again JM
  As per your advice  I have carefully studied and some trial , i am  success to insert  data into jgridview  [but not yet in dblistview] from demo app of sqlite . But still  I have problem i.e.

 HOW CAN I ADD [insert]  text from jedittext to sqlite db table  and so into jgridview ?
Kindly guide me regarding this.
Thanks againe.

[jmpessoa]

You can replace this:

'INSERT INTO ' + FTableName + '(TITLE, AUTHOR, COUNT, FIGURE) VALUES(''How To Solve It'',''George Polya'',9,null)'

by this:

'INSERT INTO ' + FTableName + '(TITLE, AUTHOR, COUNT, FIGURE) VALUES('''+EditText1.Text+''','''+EditText2.Text+''','+EditText3.Text+',null)');


About jGridView, please, see demos: "AppGridViewDemo1" and "AppGridViewDemo2"

[rsu333]

Thanks a lot JMPessoa
I have try this successively . This commands  will useful for beginner and non IT like me.
Thank you again for your kind support.