Having problem with query_create()

[lemow]

Stan,

I removed the OnKey event code too, however I still get the error:"ix=tbl.query_create()
No such field"

[Stan Mathews]

Stan,

I removed the OnKey event code too, however I still get the error:"ix=tbl.query_create()
No such field"

I'm home now but I'll zip up and attach your sample tomorrow. It gave me no errors. Must be doing something differently.

You did try with the same form I mentioned?

[Tom Cone Jr]

Ali, Alpha Five is receiving conflicting instructions from your design.

Your button is trying to run a query against the table supporting the form. (The current table.) However, in the properties of the form layout you've RESTRICTED Query Commands, Select Index, Select Range, and Navigate. This means the form cannot be used to navigate through records in its table, nor can queries be run against it. Alpha Five cannot simultaneously block queries and navigation through form properties AND ALSO run your query against the table supporting the form from your button. Do you see the problem?

Your query script will run fine if you:
a) remove the restrictions mentioned above; and
b) remove the tbl.drop() statement from your script. The drop() method is a method for index and query pointers, while "tbl" is a table pointer. No can do.

If I may offer a few further suggestions:

a) it's rarely a good idea to base a form that's used as a menu on a table that contains meaningful data. Here, I would create a dummy table, populate a single record, and base my menu forms on it, alone. Otherwise, you wind up with open data tables when other processes in your app may need exclusive access.

b) Your button script runs a table wide query in order to find all records with a specific File_no. If each record in a given table is supposed to only and always have one record that matches any given File_no I would not run a table wide query to "find" it. It's quicker by far to simply create an index on the file_no field, then when you need to find a record make that index primary and then do a find by key (<tbl>.fetch_find()). Queries are useful when you need to find bunches or groups of records all of which meet the filter criteria. They're rarely the correct choice if you are really searching for a specific, single, record.

-- tom

[lemow]

Stan,

That was the right form: MainFormFind.

Tom,

I changed the settings in the properties as you stated, but I keep getting the same error ("...tbl.query_create()... no such field")...
This is one of those weird problems!

[Tom Cone Jr]

Ok, send us the table and its data dictionaries again. We need to see the ones you changed.

What build of Alpha Five version 7 are you using?

[lemow]

Ok... here it is. basically did the changes that Stan asked earlier too... I also first removed the OnKey code event for the form but since it didn't have any effect, I put it back in.

[Tom Cone Jr]

Ali,

Your script runs fine once you finish making the changes I recommended to you. You "unchecked" the Query Command restriction, but your form still has check marks in the Restrictions for Select Index, Select Range and Navigate in form properties. In my previous post I recommended you remove these restrictions. Just remove the check marks and your script will work fine. When these entries are check you are telling Alpha Five to "Restrict" index changes, range changes, and navigation. "Restrict" means "Block" or "Prevent". Ok? The absence of a check mark means that these are NOT blocked, which is what you need in order to run your query.

I'm using build 4035 / 3025 of Alpha Five vers7.

-- tom

[lemow]

I still keep getting errors... I replaced "qfind=ix.records_get()" by "qfind=tbl.fetch_first" and did some more changes...
I did remove those restrictions Tom mentioned... The errors vary...
I am lost!

[lemow]

Tom,

I am using Build 3005, 3880 of Alpha5 ver. 7.

[Tom Cone Jr]

Ali, your version of Alpha Five is horribly out of date. Download the patches from Alpha Software. There's a "check for updates" button on your Help menu in Alpha Five.

In the meantime, here's a working example for you to tear apart. Unzip this to an empty folder. Do not mix with your development work. I've included additional sample data.

-- tom

[lemow]

Tom,

I tried opening your sample in Alpha5 but there is no form... Cannot view the code for file Example... BTW. I updated the Build version to the latest. Thanks

[Tom Cone Jr]

Ali,

My uploaded file contains a series of files. Unzip and extract them all to the same, empty, folder. Then start Alpha Five and open the Example database you'll find in that folder. It contains the Menu table and only one form, MainFormFind. If you still have trouble, I suggest you write down every step you took, so we can try to retrace your steps. If you're not able to create an empty folder, or to unzip and extract the files correctly I'm sorry I won't be able to help you.

-- tom

[lemow]

Tom,

It's not difficult to unzip the files... It's what I see in Alpha5.
I unzipped your files into the empty folder, opened the Example database in Alpha5. The Menu table shows up in Control panel, under Tables/Sets. But when right clicking on it, none of the options are selectable!
Here is what I did and it worked, I selected Table tab, selected New Table and added it from the folder...
After viewing the code editor, and running it, the prompt asks for file # just like the main database I have. But once I put in the file #, it gives error:"tbl.query_create()
no such field"
With the other complete database, it gives the same error as well...

[Tom Cone Jr]

It sounds to me like you're running the old copy.

Try this:

1) Open Alpha Five by itself. Do not double click on the Example ADB. Start Alpha Five from the Start menu.

2) Use the File / Open Database sequence from the menu to open the Example database you unzipped from me.

3) At that point examine the records in the Menu table by double clicking on it. If you don't see 3 records there, you've done something wrong. Stop, and go back to retrace your steps, all the way back to downloading my attachment, and then unzipping it again to an empty folder.

If you see three records, close the browse, choose the Forms tab of the control panel. You should see a single form. Double click it. Push the By File Number button. Read the dialog and make note of the file number you see. close the dialog, and then supply it when prompted to enter a file number. As you will see the script runs without error and the query is place in effect. You can verify this by closing the form, and then choosing the Tables / Sets tab of the control panel again. This time when you double click the table you will see only the selected record, because the filter from the query remains in effect.

This statement makes no sense to me:

After viewing the code editor, and running it, the prompt asks for file # just like the main database I have. But once I put in the file #, it gives error:"tbl.query_create() no such field"

Your script must be run from the button, it cannot be run from the Code page of the Control panel. I doubt it can be run directly from the code editor. I do not have a clue why you're doing it this way, but stop. Run it from the button, after opening the form. If you need to edit the script place the form in design mode, right click the button, choose Events, and then OnPush. Edit the script there. Then save it. Then save the form. Then run the script by pushing the button. Ok?

--- tom

[lemow]

Tom,

I really appreciate your feedback and support.
I was able to view the code just like you mentioned and worked fine (Sample database).
In the main database, when I enter a file number, it's not recognizing the table... it gives me the message:"there is no matching file number"... when I modify the code, I get other errors like I pointed out earlier. I have to try to figure this out. Thank you again for your help.