Just found a nasty bug in Designer 8.5: If I make any change to the “Database Script” element, then close the element (either by pressing the Esc key or clicking the X on the window tab), I’m not prompted to save, so the changes are lost.
Furthermore, if I manually save the element before closing, I get the prompt “The design element was modified since you started editing it. Do you want to overwrite it with your changes?”
Clicking Yes works fine, but no-one else is currently working on the same database design, so that prompt shouldn’t appear. The element should just be saved.
Subject: It seems the problem is caused by design locking
The database on which I first noticed the problem was a remote database with Design Locking enabled.
I have just tried a different database without Design Locking, and the problem doesn’t occur. A save prompt appears as expected.
If I enable Design Locking in this database, then open, modify and close the Database Script, it closes with no prompt. Disable locking again, and the problem goes away.
Subject: Re: Bug - database script - no prompt to save changes
For your problem concerning the the message prompted because the system detects that someone have edited and saved the design element you mentioned when you tried to save it. Other scenario that this will happen is if one of your colleague edited that design element of the replica of your database and replication took place before you tried to edit the document. When this message prompts try to copy - paste the script you made to a notepad then don’t save the changes you made. Try to open modified again the design element and paste the script from notepad then save it. You shouldn’t be able to see that message.