Hello fellow peggers,
I heard thru the grape vines that version 9.1D of Progress allowed schema changes to a database opened in multi-user mode, and with users accessing it.
Apparently you can check if a particular table is in use, and if not you can put a table lock on it, make your changes, recompile the code and release the table lock. If a user tries to execute a procedure that uses that table while there is a lock on it, he would get a message like "** table locked by ... wait or press CTRL-C".
Has anyone heard about this or am I dreaming.
I heard thru the grape vines that version 9.1D of Progress allowed schema changes to a database opened in multi-user mode, and with users accessing it.
Apparently you can check if a particular table is in use, and if not you can put a table lock on it, make your changes, recompile the code and release the table lock. If a user tries to execute a procedure that uses that table while there is a lock on it, he would get a message like "** table locked by ... wait or press CTRL-C".
Has anyone heard about this or am I dreaming.