Page 1 of 2

SQLite for Automagic

Posted: 20 Dec 2019 10:50
by VitPMir
Sorry for my English. Used Google-translator
flow_group_SQLite_for_Automagic_20191220_143938.xml
(35.27 KiB) Downloaded 1137 times
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
Corrected something
flow_group_SQLite_for_Automagic_20191220_173803.xml
(35.31 KiB) Downloaded 1238 times

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