disappearing fields in xbasic query

[mariusm]

I have this weird problem in an inline xbasic script.
Part of it includes a query,

tbl3 = table.open("jobbook")
query.filter = "((j_year = "+s_quote(var->vvYear)+") .and. (j_month = "+s_quote(var->vvMonth)+") .and. (j_week = "+s_quote(var->vvWeek)+"))"
qry3 = tbl3.query_create()

The three variables are global variables, and the fields all very definitely exist in the table.

What happens is, when I first run the query, I get an error saying qry3 = tbl3.query_create() No such field.
BUT if I close the form and re-open it, the query runs with no problem. If I change the value of a variable, it again doesn't run unless I close and reopen the form.
I thought my variables are disappearing, but if I check for them in the code editor, they are there. I do not have other variables with the same name anywhere in my application. I tried dim-ing the variables again in the script, just in case - it didn't help. I tried xbasic_wait_for_idle() in case there was a timing issue, but there wasn't. I tried refreshing the form before running the script. No joy.
I tried the query with and without s_quote, it does the same thing either way.
So I am out if ideas.
Have any of you run across this? How can I get around it?

[Al Buchholz]

Re: disappearing fields in xbasic query

Use a debug(1) to look at the value of query.filter after it is set and prior to qry3 = tbl3.query_create()

or

use msgbox(query.filter) after the query.filter value is set.

[mariusm]

Re: disappearing fields in xbasic query

Thanks Al, this is getting strange.
msgbox(query.filter) gives me a correct filter - e.g. ((j_year = "2016").and.(j_month = "Jan").and.(j_week = "1"))
but the query doesn't run.
However, if I place a button with the very same script on a different random form, it runs without a hitch, using the variables set on this form. The script is bigger (236 lines), not just a query, but it is the query that fails. I made a button just with the query and nothing else, and it still fails on this form.
I am beginning to wonder if I don't have a corrupt form, I will rebuild it from scratch and try again.

EDITED to say that, yup, it was a corrupted form. A new form with the exact same script runs with no problems.
I wonder if it's a compatibility problem, the form was originally built in version 11 of Alpha.

[DaveM]

Re: disappearing fields in xbasic query

Try a compact before all the work?

[Al Buchholz]

Re: disappearing fields in xbasic query

Is the table jobbook part of the set(or only table) that the form is based on?

build a query and save it, then run that query.

In view mode, query, query by expression, save the query.

In Design mode: Make a button - action scripting - Index/Sort - Run Saved Query (or use the code generated in your script)