Recent

Author Topic: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?  (Read 7242 times)

rsu333

  • Jr. Member
  • **
  • Posts: 77
WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« on: December 15, 2021, 08:25:28 am »
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

  • Hero Member
  • *****
  • Posts: 2109
Re: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« Reply #1 on: December 15, 2021, 06:06:20 pm »

What AppSqliteDemo1 (and AppSqliteDemo2, ...., etc)?
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

rsu333

  • Jr. Member
  • **
  • Posts: 77
Re: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« Reply #2 on: December 16, 2021, 03:20:46 pm »
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

  • Hero Member
  • *****
  • Posts: 2109
Re: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« Reply #3 on: December 16, 2021, 05:19:52 pm »


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


"AppDBGridViewDemo1"
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

rsu333

  • Jr. Member
  • **
  • Posts: 77
Re: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« Reply #4 on: December 17, 2021, 07:48:36 am »
OK, thanks

rsu333

  • Jr. Member
  • **
  • Posts: 77
Re: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« Reply #5 on: December 24, 2021, 03:17:16 pm »
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

  • Hero Member
  • *****
  • Posts: 2109
Re: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« Reply #6 on: December 26, 2021, 07:25:52 pm »
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"
« Last Edit: December 26, 2021, 09:29:09 pm by jmpessoa »
Lamw: Lazarus Android Module Wizard
https://github.com/jmpessoa/lazandroidmodulewizard

rsu333

  • Jr. Member
  • **
  • Posts: 77
Re: WHICH IS BEST DEMO OR EXAMLE FOR LEARN SQLITE IN LAMW ?
« Reply #7 on: December 28, 2021, 01:07:40 pm »
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.

 

TinyPortal © 2005-2018