I wanna change query in runtime environment in developer/2000 reports with a button through DO_SQL .
My report depend on
select * from user;
Pl/Sql code for button
Procedure U_1ButtonAction is
SRW.DO_SQL('SELECT * FROM USER
0REDR BY USER_NAME');
WHEN SRW.DO_SQL_FAILURE THEN
SRW.MESSAGE(100, 'ERROR WHILE CHANGING ORDER.');
In above procedure there was an error or any change plz write
write an example.
Click Here to Expand Forum to Full Width