Another crazy problem. I have two data-entry forms, QUOTE and ORDER and they use two separate files, QUOTES and ORDERS. I call them from a form that is the application's point of entry. I can modify and save records in both forms. If I am running ORDER, I can call up QUOTE, change a record and save it.

Here comes the crazy part. If I am running QUOTE instead and open ORDER from it, I cannot modify the order record or save it.

This was not a problem in 4.1.3.

Any ideas?

Bob,

When you say you can't modify the record, is that just another way of saying you can't save your changes? Or do you mean you can't even enter anything (i.e. the form is read-only/disabled)?

You said it worked in 4.1.3. Does that mean you upgraded to 7.0x? How long ago did you upgrade?

Can you only launch the forms from the application start point or are you launching them from each other?

Finally, are you using any promoted events?

[email protected]

SRP Computer Solutions, Inc.

Don, read below for my answers.

When you say you can't modify the record, is that just another way of saying you can't save your changes? Or do you mean you can't even enter anything (i.e. the form is read-only/disabled)? I CAN ENTER THE CHANGES BUT NOT SAVE THEM.

You said it worked in 4.1.3. Does that mean you upgraded to 7.0x? How long ago did you upgrade? I UPGRADED TO 7 IN APRIL OR MAY.

Can you only launch the forms from the application start point or are you launching them from each other? I DO BOTH.

Finally, are you using any promoted events? I WILL BE GLAD TO ANSWER THIS ONE ONCE YOU REFRESH MY MEMORY AS TO WHAT A PROMOTED EVENT IS.

Bob,

A promoted event is simply an event which is not tied to a specific control. They are also known as "generic events" and "global events".

Promoted events are now documented in the online 7.0 Programmer's Reference Guide. My guess is that if you needed to be reminded as to what they are then you probably don't have any in your system. You have to go through a little work in order to establish them in your system.

[email protected]

SRP Computer Solutions, Inc.

Bob,

Seems like the obvious issue is in your WRITE event. Are you using a scripted WRITE event anywhere? If so, what does the logic look like?

[email protected]

SRP Computer Solutions, Inc.

Don, I checked the documentation on promoted events and you are right, I do not have one. And here is how I save the record in a stored procedure: ANS=SEND_EVENT('ORDER', 'WRITE'). To keep this simple, if ANS=' then the form clears. Otherwise, it displays an error message. Remember, the puzzle is that I call the same form either from the point of entry form or from the QUOTE form. The very same form using the same stored procedure works in the former case but not the latter.

Go figure.

Bob,

Is that code connected to a menu item or a pushbutton? What happens if you use the QuickEvent/Write a Row instead of the stored procedure?

Something that concerns me is the fact that you hardcode the name of your form in the Send_Event function call. Are your forms multi-instance? If so, then that code won't work all the time.

Something else to test, try closing the form after you make some changes. Do you get the Savewarn message? If so, what happens if you say "Yes"? Does it actually save the record?

[email protected]

SRP Computer Solutions, Inc.

Don, here are my answers.

Is that code connected to a menu item or a pushbutton? What happens if you use the QuickEvent/Write a Row instead of the stored procedure? Will not save.

Something that concerns me is the fact that you hardcode the name of your form in the Send_Event function call. Are your forms multi-instance? I have three forms open: the point of entry with various buttons to open other forms; QUOTE and ORDER. Only one copy is open at a given time.

If so, then that code won't work all the time.

Something else to test, try closing the form after you make some changes. Do you get the Savewarn message? NO If so, what happens if you say "Yes"? Does it actually save the record?

I checked the save scripts for both forms and the send_events are all coded similarly with @window and not the form name.

Puzzling.

Bob,

I'm not sure what it might be. You might be able to isolate a system problem by creating an Engine log. You might also want to run SCAN_REP to rule out any orphaned events that are causing you fits.

If you can package this up fairly easily I'd be happy to look at it for you.

[email protected]

SRP Computer Solutions, Inc.

SCAN_REP is clean. I will run an ENGINE logo and post it to you. Thanks for your help.

I am not sure but can it be the relational indexes??

Do you have a relational index between both the files and when you try to update the Order form the Quote the record is already open and locked at the back screen???

Thanks

Prashant

Good question. These two tables do not share a relational index. The ORDERS table does have a relational index with the CUSTOMERS table.

I initiate the save process with F9. If I substitute control-s, it still does not work. Out of desparation, I added a pushbutton that calls the stored procedure for saving with a alt-s as a speed key. That works. Now, bear in mind, all this applies only when I call the ORDER form from the QUOTE form. Otherwise, F9 works just fine.

Don, I would like to take you up on your offer of looking at the application. If you post your email address or send it to [email protected], I will give you the links to my ftp site.

We wonder if there is some menu conflict going on in some way. As the push button works it follows that it is not the save logic at fault but the launching of the save logic. Can you physically select the menu options for save with a mouse?

The Sprezzatura Group

World Leaders in all things RevSoft

The second menu does not work if the first form is open.

How are you calling the procedure i.e. have you linked your procedure to the windows write event by using Quickevent options?

We normally Call the Procedure in the write event of the form as script event. Also try using FORWARD_EVENT instead of SEND_EVENT

When you say it doesn't work - you can select it, drop down and make your selection and nothing happens? Or it can't be activated?

[email protected]

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

To answer Sprez and Prashant–

As it turns out, thanks to Don's looking at this, none of the menu functions are working. Something from the first menu is interfering with the second form's menu. That includes some messages under the help selection.

Prashant, I have the same problem whether the save is a quick event or script. I put a debug at the top of the script and the system is not even getting that far.

Quite a challenge.

Problem solved thanks to Don.

The last page tab control on form 1, QUOTE, caused this mess. Although it looks identical to the preceeding tab, deleting it, copying over the preceeding tab and putting in the right page number in the quick event restored all the proper behaviors.

Looks simple now. The $64 question is why?

Thanks Don.

View this thread on the forum...