runNamedQuery Script help

steven.cox · October 9, 2020, 6:29pm

Hi all,

I cannot figure out why this script fails. I have restarted Designer with the same results.

From the Script Console…

The binder_select_index query works and has a matching parameter and the commented section works as expected.

What am I missing?

Thanks, Steven

code_skin · October 9, 2020, 6:37pm

In the script console screenshot: line 2 (end of the line) binder_name parameter should be binder perhaps.

ryan.white · October 9, 2020, 6:39pm

I think you might have flipped the dictionary parameter with it’s value

try

binder = "another binder"
binder_id = system.db.runNamedQuery("binder_select_index", {"binder_name":binder})

steven.cox · October 9, 2020, 6:48pm

That’s it!!! I was looking at the parameter definition backwards!!

Thanks for your help!!

Steven