"no such field" error is selective

[acceptthis]

Help Anyone,

I'm getting a "no such field" error when running a script. It's related to the query I'm trying to create in the script.

The strange thing is, it works fine when I run the script in the Code Editor, but when I try to run the script within a button on the form, I get this error.

What's up? Has anyone had this problem?

Here's the code:

estnum = Estimate_Navigator:number.value 'Gets est. num from Navigator form
est = table.open("bids")
query.filter = "Number = " + s_quote(estnum) 
indx = est.query_create()
records = indx.records_get()
estname = est.Last

items = table.open("memo_lines")
query.filter = "Bid_no = " + s_quote(estnum)
items_indx = items.query_create()
items_records = items_indx.records_get()

The problem occurs in the memo_lines table when it goes to create the query.
I created the script in the Code Editor and it runs just fine. But when I made a button on the form to run it, I get the error.

[Stan Mathews]

Re: "no such field" error is selective

estnum = Estimate_Navigator:number.value

Should cause an error when run in the code editor unless you have dimmed estnum as global somewhere or have the form open. Better attach a sample so we can see what is happening.

[acceptthis]

Re: "no such field" error is selective

Thanks for the quick reply,

It's just the opposite, it causes the error when it is ran in the form.

yes, I have the form open. If not, I get a different error.
That's why I thought it would be no problem just make a button to run the working script.
I'll work on packaging it up so you can see.

[acceptthis]

Re: "no such field" error is selective

I've tried to zip up just a few files, but I don't know what I'm doing, and it's not worth the trouble for me to figure it out.
Thanks for your willingness to help.

[G Gabriel]

Re: "no such field" error is selective

estname = est.Last

??
try:
dim estname as c
estname =bids->Last

[acceptthis]

Re: "no such field" error is selective

Thanks for the suggestion, and I tried it, but that didn't work either.
The problem doesn't seem to be in the estname variable because it works on the "bids" table.

query.filter = "Number = " + s_quote(estnum) 
indx = est.query_create()

When I debug it, I get:

Bid_no = "01896"

Where 01896 is the correct bid number. And this is the same syntax when I do a filter query just regularly.
Go figure.

[G Gabriel]

Re: "no such field" error is selective

Try this:

estnum = Estimate_Navigator:number.value 'Gets est. num from Navigator form
est = table.open("bids")
query.filter = "Number = " + s_quote(estnum) 
indx = est.query_create()
records = indx.records_get()
estname = est.Last
[B]query.order=""[/B]
items = table.open("memo_lines")
query.filter = "Bid_no = " + s_quote(estnum)
items_indx = items.query_create()
items_records = items_indx.records_get()

[acceptthis]

Re: "no such field" error is selective

That work!!

When I debugged it, query.order variable was

query.order = DATE

now it's "".

When query ran, it was probably still trying to sort things by the DATE field, which doesn't exist in the Memo_lines database. How many times do I have to be told to declare everything in a query. Maybe now I'll learn.

It's still interesting that it doesn't have the problem when I'm running the script in the Code Editor window.

Thanks again.

[Tom Cone Jr]

Re: "no such field" error is selective

Brad, the values assigned to

query.filter
query.order
qurery.options

persist. They're global.

You should always set or re-set all three when running a query. Otherwise your present query will be using options, filter, or order parameters from a previous query.

-- tom

[acceptthis]

Re: "no such field" error is selective

Thanks. I'm a slow learner.

[MikeC]

Re: "no such field" error is selective

G,

Good catch on what could have been a VERY easily overlooked mistake! :)