query_create issue

[scottly]

Hi

I have a query which I am trying to add to a script, however, it keeps getting a 'field not found' error. If I run the query in the Interactive window then it works without complaining and the correct result is returned. If I cut and paste that query into a script running off a button (onpush) then the field not found error occurs on the qry_rd=rds.query_create() line - see below.

I have other queries very similar to this and they work fine in a script.. Can anyone shed any light - could it be a table corruption of some sort.. (I have re-indexed and packed the table)?

rds=table.open("racedetails")
query.filter = "races_raceno=9"
qry_rd=rds.query_create()
nrecs=qry_rd.records_get()
a5_show_variable(nrecs)
rds.close()

[scottly]

RE: query_create issue

Futher... if I put the code in the oninit script of my form it runs fine. As soon as I out it under a button/onpush script it returns an error - weird (and frustrating!)

[scottly]

RE: query_create issue

Plot thickens:

If I remove the below my oninit code in the form, then the above query code works off a button on that form. However, if I use the same code in another script on a button in the same form (that contains other unrelated queries) then it fails. It is like I have hit some sort of query_create limit..

Dim ws_nswbalin as N global
mt=table.open("meetings")
query.filter = "meeting_date=date()"
query.order = "meeting_date"
qry_dups = mt.query_create()
nrecs=qry_dups.records_get()
if nrecs > 0 then
'Displays a message box (style:'Yes, No Buttons', image: 'Information symbol', id: 'msg_delit').
DIM SHARED msgdelit_result as N
DIM SHARED msgdelit_YES_Button as L
DIM SHARED msgdelit_NO_Button as L
msgdelit_YES_Button = .F.
msgdelit_NO_Button = .F.
title_var = "Meetings Exist for Today - Delete Existiing Details?"
message_text_var =

[scottly]

RE: query_create issue

Solved - query.order had a value in it from a prior query - trap for not so young players..

[Tom Cone Jr]

RE: query_create issue

Is 'racedetails' a table or a set?

Is 'meetings' a table or a set?

If either is a set, is the other part of it?

I'm thinking maybe you're having a naming issue with the automatic aliases Alpha Five assigns when table.open() runs. Check the docs on table.open() if this is a possibility.

-- tom

[Tom Cone Jr]

RE: query_create issue

Scott,

good catch.

It's hard to see something that's not there.

Your post reminds me that others have recommended that whenever a script runs tbl.query_create() one should always fill in order and options properties fo the query object, in addition to the filter property. I'd forgotten about it until you posted your solution.

-- tom

[Stan Mathews]

RE: query_create issue

Scott,

I think that's worthy of writing up for the tips section. Might help someone else down the line.

[scottly]

RE: query_create issue

Hi Stan

It would be good if A5 reported which field was not found rather than just reporting that a field was not found.

Regards,
Scott