Thread: D2k
-
Hi
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
Example
Procedure U_1ButtonAction is
begin
SRW.DO_SQL('SELECT * FROM USER
0REDR BY USER_NAME');
EXCEPTION
WHEN SRW.DO_SQL_FAILURE THEN
SRW.MESSAGE(100, 'ERROR WHILE CHANGING ORDER.');
RAISE SRW.PROGRAM_ABORT;
END;
In above procedure there was an error or any change plz write
or
write an example.
Thanx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|