SQL Workers

Das Goravani goravanis at gmail.com
Wed Nov 30 15:47:28 UTC 2022

Thanks Doug.

I switched back to Objects and Rob Mostyn figured out that the bind vars list actually has to be a row, you need one row for each query, not a list.. when I switched to bindvars row I immediately got success.. no crash, and I got back multiple results hits on $completed. 

It’s actually really simple to use this worker object if you get the little details just right.

The documentation is a bit off.. in a few little places.. enough to make you fail however.. like it says Bindvars List, but no, it has to be a row.

It says Object references.. but no,, it has to be objects. 

Or I read it wrong. 

Glad I got this working. 25 log ons and queries consecutively takes awhile, but stacked up on top of each other it is much quicker.

SQL Worker is a bliss thing.. really cool.. asynchronous power house when you need it

Das Goravani

More information about the omnisdev-en mailing list