Page 1 of 2
SQLite for Automagic
Posted: 20 Dec 2019 10:50
by VitPMir
Sorry for my English. Used Google-translator
Fixed version here:
http://automagic4android.com/forum/view ... 776#p26751
Re: SQLite for Automagic
Posted: 20 Dec 2019 12:59
by jassing
Awesome work!
But... The insert routine does not work for me...
Great work, much appreciated!!
Re: SQLite for Automagic
Posted: 20 Dec 2019 13:42
by VitPMir
Re: SQLite for Automagic
Posted: 20 Dec 2019 15:02
by anuraag
Good effort.
I have already tested same java functions but problem here is database takes some minutes to close.
Re: SQLite for Automagic
Posted: 20 Dec 2019 19:24
by jassing
VitPMir wrote: ↑20 Dec 2019 13:42
Corrected something
flow_group_SQLite_for_Automagic_20191220_173803.xml
Works perfectly here! Thank you for sharing your work!
Re: SQLite for Automagic
Posted: 21 Dec 2019 06:59
by VitPMir
anuraag wrote: ↑20 Dec 2019 15:02
Good effort.
I have already tested same java functions but problem here is database takes some minutes to close.
Renamed 'objDb' to 'global_objDb', opened the database.
After 12 hours, I performed INSERT. Everything worked.
Re: SQLite for Automagic
Posted: 21 Dec 2019 09:22
by anuraag
@VitPMir
Working perfectly. Can you give some reference where i can learn more about sQ or sWHERE Variables you used?
Re: SQLite for Automagic
Posted: 21 Dec 2019 10:06
by VitPMir
anuraag wrote: ↑21 Dec 2019 09:22
Can you give some reference where i can learn more about sQ or sWHERE Variables you used?
https://www.guru99.com/sqlite-query.html
https://www.sqlitetutorial.net
https://www.sqlite.org/lang_select.html
Re: SQLite for Automagic
Posted: 21 Dec 2019 17:18
by Desmanto
@VitPMir : That's Amazing. I should reverse engineer your flow to study it. Thanks.
Re: SQLite for Automagic
Posted: 31 Jan 2020 18:40
by fagci
Sorry, but in every Android phone sqlite3 console utility exists. So, no need to write more code instead of SQL
Example:
http://automagic4android.com/flow.php?i ... e616f2e3b5