WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
lazarus / 43-Android

----------------------------------------------------------------------
rsu333 · 2021-12-15 07:25

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 · 2021-12-15 17:06

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

----------------------------------------------------------------------
rsu333 · 2021-12-16 14:20

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 · 2021-12-16 16:19

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


"AppDBGridViewDemo1"

----------------------------------------------------------------------
rsu333 · 2021-12-17 06:48

OK, thanks

----------------------------------------------------------------------
rsu333 · 2021-12-24 14:17

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 · 2021-12-26 18:25

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 · 2021-12-28 12:07

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.