View--Form Problem

[rgw]

Would appreciate any insight into a form which has suddenly stopped working.

Form is based on a parameritized view of the zip code file with the user inputting a zip code. Once the zip has been selected it is shown in a grid and if correct the user confirms the single zip or selects the proper zip/town combination for zips with multiple towns.

Form has worked fine for ages but on selecting the form from the menu I can see that it is correctly selecting one record from the zip file but then it continues on its way and selects all of the 62,000 odd zip codes from the file.

The form does not run at all and never seems to get the focus. The view works properly from the view designer and selects the proper zip code.

Many thanks
rgw

 

[TamarGranor]

What does SYS(3054) tell you?

Tamar

 

[rgw]

Tamar:

Sorry to be a bit slow on this but where would I ask it? The form doesn't run at all--i just see it showing the proper query and then it goes off and queries it again and brings back the entire count as a result.

If I write a new form and put the grid/view it works. Would like to figure out what's going on as to fix it when it happens again.

Many thanks
rgw

 

[StewartUK]

rgw,

You say it suddenly stopped working.

Have you changed anything in the code of the form (or it's class)? If so, are you able to go back and comment-out the changes and see if it works again?

In which method is the code that makes the selection? Is it possible that the method is being run twice - try putting a WAIT WINDOW in the method.


Hope that helps,

Stewart
PS If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[rgw]

Stewart

Thanks for the response. Haven't changed a thing in the form. Problem is that the form never fires. The way it has worked for ages is you select the form from the menu and the first thing you see is the request from the view for the zip code. I still see the view request and it goes ahead and selects the zip code and then it queries the table again and selects all 62,000 records. I've put some 'waits' in the load/init/and the de in the form and it never gets there.

Logic tells me I have done something but I can't think where.
rgw

 

[rgw]

Stewart/Tamar:

Thank you for your help. I have been rebuilding the form from the ground up and it the problem seems to be the existence of a second view in the form. The first view brought in the zip/town combos and the second view (which was not queried) merely joined the base data and the payment tables on a reference number. Keeping the de with just the zip view and a customer file everything works as should be. When I add the second view the form no longer runs and I get the two queries. Little bit baffled as the second view is merely used as a convenient way of joining the two tables and has worked just fine for a long time. I'll just use the tables there and not the second view.

This either keeps you young or old. Not sure which.

Once again many thanks
rgw