Oracle Forms

Hi All,

I'm using forms 6i and I'm facing a problem : when executing a query on a data block the form's status cahnges to "CHANGED", my code as follows :

GO_BLOCK('Update_Procedures');
SET_BLOCK_PROPERTY ( 'Update_Procedures', Default_Where , 'VisID = ' || '''' || :uVisitID || '''' );
EXECUTE_QUERY;

When I comment (--EXECUTE_QUERY;) EXECUTE_QUERY statement then execute triggr, the form's status is "QUERY" . It means that the problem lies in EXECUTE_QUERY statement.

I didn't make changes to that block before executing the query.
I did a lot of similar queries on other data blocks in the same from with no such problem...I tried a lot of tricks but didn't help, so I need your help


Thanks in advance..



Regards,

LoveSoul