Every now and then I get on a specific form this error
Fout tijdens het laden van Primary Key data,com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -143: Column 'undefined' not found ASA Error -143: Column 'undefined' not found
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -143: Column 'undefined' not found ASA Error -143: Column 'undefined' not found
It has been on my nerves for some time…but I can not seem to figure out what is wron. At first I thought it was an error in a method, but usually servoy will tell which method a error comes from.
I have been looking in the onshow and onload method but there arent any.
Problem is that it occurs sometimes…I am at a loss here
You are doing a query with probably variable column names (or it looks like it).
I think that that variable is ‘undefined’ (often happens with an empty argument in a method).
I’d search in that direction…
Wouldn’t Servoy then tell me in which method (using debugger) the problem is. I have these kind of errors before but Servoy tells me nicely where the problem is located.
Furthermore I have been looking in every form and tabpanel to locate a method that would produce a query error… and didn;t find any
It seems that there a method beeing called, and it shouldn’t…and I really cannot find why this Method is called.
It’s an onShow method of form B.
The funny thing is when I go to form A…everything is allright.
If I go to form B, the onshow is triggerd and that’s ok…if I now proceed to form C and then A…it executes again the method on form B.
I searched my ass off…
Also when an Onshow method is triggered for the first time arguments[0] = true. If the same onShow is triggered again then arguments[0] doesn’t exist.
But when I go to form B,C and A…I get arguments[0] = false in the onShow method…what does that mean???
For now I am gonna put a if() to prevent the undefined error … but it annoys me that can’t find the cause.