Hi all,
I'm stuck on some code that was working in a previous release we had and I can't seem to get it to work correctly at this point.

I have a query that I run in a Robot script that updates a table in the database from a table that I've created. Before, it always returned the number of rows changed which was the value that the return code variable returned. However now it's only returning a -1.
What's got me stumped, is that it actually is updating the table with the correct values, but it's not returning the correct value, hence giving me an error.

Anyone know what could be causing this?

Here is the query I'm using.

Query = "Update osCompanyModulePolicy SET CPValue = ValidValues From Section8PolicyTest1 Where PKN = fkMLSosPolicy and fkosCompanyModule = 500004"

Thanks for any help or ideas that can get me on the right path.


A living entity in a QA/cubicle sensory deprivation chamber!
Wow, it really is a Dilbertian world....?