I did do some installs when I was in terminux to get it working.
I had thought it was installing them on my phone in general but I'm starting to think that the install only works for terminux.
When I first called sqlite3 it reported sqlite not installed and recommended I installed the package. Once I did it worked like a charm!
So based on your comment and my experience I'm thinking the install only works within terminux shell and not in a general way on my phone linux background.
I tried putting the sqlite3 file on my SD card and calling it from macrodroid. Even though the file says rwxrwx macrodroid wouldn't launch it.
I've put soooo many hours over the last 3 years trying to get this to work
Meanwhile I found this and wonder if it might be helpful to my cause:
Setup Termux on Android. GitHub Gist: instantly share code, notes, and snippets.
gist.github.com
.
Tasker sqlite plugin seems to no longer work. Tasker now has on board sql calls that work, but there's no way to pass the query or the results between macrodroid and Tasker.
I also tried memento db, which is totally useless because you can't query the db, only do puts. What use is saving data if you can't retrieve it!?
I'm totally willing to pay for feature development for anyone to get sql working through macrodroid.
Any help is much appreciated.