No Cursor on SQL Query Insert Into

12 views
Skip to first unread message

whitedavidp

unread,
May 5, 2022, 2:17:37 PM5/5/22
to Tasker
Am trying to move from the old SQL Plugin to the built-in SQL Query...

You can see my raw sql command and other parameters in the attached screenshot and I have attached error message I get after I exit and re-enter Tasker in the other screenshot.

I am forced to put in something for the variable array parameter although it seems un-needed. I found some samples posted in TaskerNet that do basically the same thing and they put something in there as well. In my case, the variable %nada has never been set.

This sql works fine in the plugin. And the database file absolutely exists and is located at the root of my internal storage. So permissions should not be an issue.

Any idea what is going wrong here? Thanks


Clipboard02.jpg
Clipboard01.jpg

whitedavidp

unread,
May 5, 2022, 2:24:38 PM5/5/22
to Tasker
Never mind. I got some more info from the logs and the first two values required quotes (") around them. Not sure why this was not needed in the SQL Plugin but there were not. So I did a copy/paste into the new SQL Query and did not even consider it. Sorry
Reply all
Reply to author
Forward
0 new messages