×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

New field generate the message "Save Changes?" in Item Maintenance

New field generate the message "Save Changes?" in Item Maintenance

New field generate the message "Save Changes?" in Item Maintenance

(OP)
I have added a new field in the Basics tab of IM0101 screen. I have called a function to display the data in this new field when the Description field got focus. The function to save the data is called when this new field loses focus. Here is the issue. I get the error message "Save Changes?" with Yes/No/Cancel button from Macola ES each time I clicked on Cancel to close the screen. Changing or not the data in this new field does not matter. It does not even go into the function to save the data when clicking on Cancel.

Why do I have this message all the time I close the screen?

RE: New field generate the message "Save Changes?" in Item Maintenance

(OP)
What trigger the "Save Changes?" message box?

Thanks in advance

RE: New field generate the message "Save Changes?" in Item Maintenance

The MacformSave event should do it, but I am not in front of Macola ES at the moment. Please give this a try and let us know.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: New field generate the message "Save Changes?" in Item Maintenance

(OP)
How can I get that message when there is no change in the form? I just populate a custom field from the extra_6 table field imitmidx_sql.

RE: New field generate the message "Save Changes?" in Item Maintenance

Populating an extra field in the screen IS a change in the data, hence the prompt. Try instead on the macform_save event to just change the value in the extra field with a SQL statement, without ever populating the field on the screen.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: New field generate the message "Save Changes?" in Item Maintenance

(OP)
That is a good idea but the thing is it does not go in the macform_save event when I press Cancel. This is where I got the prompt. I looked but did not find any event for the Cancel. Does it exist?

RE: New field generate the message "Save Changes?" in Item Maintenance

But if you hit cancel, you do not want it to save anyway do you?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: New field generate the message "Save Changes?" in Item Maintenance

(OP)
No I don't want it to save when I hit Cancel but I get the prompt. I think I get the prompt because I populate the field with the extra_6 field value on the description_gotfocus event. If I am not populating the value from a SQL query, it is always blank even if there is data in the table for the item selected.

I tried to save the value in the table as soon as I display it but I still get the prompt when I hit Cancel.

Here is what I want to do. I have create a custom text field from the Designer to show the value of the extra_6 field from the imitmidx_sql table. I looked if there was a hidden field for the extra_6 but there was not. Because the custom field on the screen is not directly related to extra_6, I have created a function in macform to display the value of extra_6 for the selected item. This function is called in the getfocus event of the Description field. There is another function to save the value of the extra_6 in the database and it is called on the losefocus event of the custom field.

So far, what ever I am trying to do, I always get the prompt. To get rid of the prompt, I have to comment the function to display the value of extra_6 in the custom field on the screen. But I have to see the value somewhere in the screen and the user can change the value as desired.

Is there something I do wrong???

RE: New field generate the message "Save Changes?" in Item Maintenance

(OP)
The solution I found is to display as read only the value of the extra_6 field on the screen. Create a push button to call a new form that allow to change de value of the extra_6 in the database. Just displaying the extra_6 value as read only get rid of the prompt.

Thanks for your help!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close