>[...] my views cant be reverted and when they did (for some reason) an error came up specifying that alias (...) has uncommitted changes. Can you tell me what might be causing this and how can I get rid of this error. Actually this error comes up when I try to do REQUERY() when form is refreshed.

What's causing it is that when you do the REQUERY() you have some uncommitted changes still in the buffer. You have to either TABLEUPDATE() to commit them, or TABLEREVERT() to revert them, before REQUERY()ing the data source. It sounds like you confused REQUERY() with TABLEREVERT(). REQUERY() re-fetches the data from the table. TABLEREVERT() undoes the changes in the current buffer.

HTH,
Rich.