Out of context error

[Clunes]

I have a script that uses an xdialog to select items from a list view. Once selected a number of actions occur which updates about 6 different tables depending on which table is needed. I have a snag in that I get an error on a particular query_create() telling me cannot create function is out of context.

It all works fine until the list needs to follow the Select case Whichtable = Equipment. From there it also works fine until the T3.query_create line. I am presuming there is something wrong with the query.filter which is

query.filter = "LID = val(var->MYID).and.loanitemid = Val(var->LLID)"

I can actually get it to work when I change the filter to be only "LID = val(var->MYID)" but this may not get the specific record that I need to change at the time

I have attached the script and the tables, but you wont be able to run it without the tables concerned which are quite large. If someone can see the issue before I do this that would be great

[Tom Cone Jr]

Re: Out of context error

Mark, don't have time to review this now, but you should review your script with an eye open to the fact that all disk activity will be multitasked by Windows. If you're hitting the same table more than once it's likely you have a timing issue. Work being done in earlier parts of your script may not be finished by the time the script gets to a later section that hits the same table. Another way to express this is to tell you that the script will not stop while a query is being run, records are being fetched, and then changes saved... it's easily possible that all of your queries are running in different threads concurrently.

[Clunes]

Re: Out of context error

Thanks for the quick reply. In trying to nut this out I actually thought it may be a table open isssue, so I trapped the particular table and checked first and got a heathly closed flag. I thought it may have been multi issue, but when I give it a simple task for only one record that matches the criteria and follows that path, the error occurs.

If I change the query filter as described in my post it works fine all the way with all tables not matter what path the select takes

I will look at a restructure that handles one thread completely befor moving to the next

[Stan Mathews]

Re: Out of context error

I can't get into Alpha at the moment but I do notice two things.

The construct in Alpha is

select
case something
'statements

case something else
'statements

end select

and you have


select case whichtable
case whichtable = "Equipment"

The part in red seems incorrect but is probably being ignored.

Also you have no spaces before or after the .and. in the problem filter where you do in the others.

query.filter = "LID = val(var->MYID) .and. loanitemid = Val(var->LLID)"

Not sure if that would cause the problem.

As a side note, I am in the habit of writing such filter expressions as

query.filter = "LID = "+val(Var->MYID)+" .and. LoanitemID = "+val(Var->LLID)

to ensure that the variables contents are substituted for the variable in string expressions.

[Clunes]

Re: Out of context error

Thank you Stan - it was the query filter. I cahnged to your suggestion and it now works fine

While the select case was wrong, it made no difference and neither did the spaces