No records In Query Error message

[barry685]

I have a form that is based on a set. Currently the tables are empty. If a menu button calls the form (with AS) I get an error message " NO records in Query". If I open the form through the control panel it opens properly.

[Stan Mathews]

Re: No records In Query Error message

When you create an Action Scripting element to open a form or browse you can specify, among other things

Optionally, specify the record selection criteria to apply in addition to those defined in the layout. Note that you can specify to enter a new record.

Check the "innards" of your action script to see if you set a filter.

[barry685]

Re: No records In Query Error message

Hi Stan,
I deleted the Action & reapplied it. All I am doing Is using the "Open Form or Browse Layout" Action and specifying the form. I am not doing anything else (other than to do no other criteria) and I still get the error message.

[Mike Wilson]

Re: No records In Query Error message

Barry,
Is there a query event on the Form OnInit, OnFetch, or OnActivate Form Event, or on the OnArrive event for the first field in the form that gets focus when the form is opened?

[Stan Mathews]

Re: No records In Query Error message

That is strange. You didn't happen to define any child table filters in the set definition?

[barry685]

Re: No records In Query Error message

Barry,
Is there a query event on the Form OnInit, OnFetch, or OnActivate Form Event, or on the OnArrive event for the first field in the form that gets focus when the form is opened?

There is only a Set Index.
I will upload a sample

[barry685]

Re: No records In Query Error message

Try the Accounts Button on the Main Menu.

[Stan Mathews]

Re: No records In Query Error message

You have an order expression for the account form

L_name+F_name

I believe that until you enter the first record this causes the failure because Alpha is really evaluating a filter and an order expression to put the records in the order you want. The filter is .T. to show all records, but that fails without any records, thus the message.

Putting it another way, you can't open a form based on an empty table/set without starting a new record but your action script tries to do that.

[barry685]

Re: No records In Query Error message

You have an order expression for the account form

L_name+F_name

Still don't understand why I get no error message when opening the form directly from the control panel.

[Stan Mathews]

Re: No records In Query Error message

Your action script attempts to order the set by last name and first name and display the records found in that fashion. It fails.

Opening from the control panel throws the form into enter mode since there are no records (default behavior).

[barry685]

Re: No records In Query Error message

Thanks Stan,

[barry685]

Re: No records In Query Error message

Stan,
Would appreciate it if you can try the following, Add a couple of Account records. Exit the form. ReEnter the form activate the Accounts Tab and go into Enter mode. You will see that the screen switches to the List Tab. I need the screen to remain on the Accounts Tab. Any Ideas?
Barry

[Stan Mathews]

Re: No records In Query Error message

Try editing the form's oninit event, use action scripting, objects properties, activate an object, choose last name. Having trouble here doing that but I think it must be a problem with v8/v9 since I'm using v8.

Alternatively create an action script inline xbasic with the code

tabbed1.tab_set(2)

for the same event.