winqry ERR=42

[edjack]

I posted this in the past but never found a solution.
Getting ERR=42
Program .../lib/_plus/winutl/winqry
Line: 1875
Can someone point me in the right direction to solve this?
thnaks

[Devon Austen]

Is this still version 13.10?

If you open up that program on the system that gets the error is there a line 1875 and if so what is that code?

If there is no line 1875 you may have to open up a trace window and then cause the error to happen and then look through the trace.

Can you bypass your error handling to see if you can get the real line number?

[Jane Raymond]

If the version is 13.10, then line 1875 is:
1875 LET _HideCol=NUM(_HideOpts$(i,1))
Error 42 would indicate that the subscript i is out of range. The _HideCol array is dimmed to 200, so if you have more than 200 columns in your query, this would cause the issue.