| Problem in blocks and canvas [message #142067] |
Thu, 13 October 2005 06:34  |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
hi ,
In a single form i have two canvas, consider A and B
if i compile A (data block canvas )i am getting only B canvas output, if i compile B canvas i am getting B canvas output,
In canvas A i have various blocks , i have to execute query .
How to access both canvases...........
and one more thing is ,
i have to access A blocks through B canvas
what r the criteria i have 2 consider....
what is the solution,,,,,,,,,,,,,?
|
|
|
|
| Re: Problem in blocks and canvas [message #142072 is a reply to message #142067] |
Thu, 13 October 2005 06:42  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
I dont have Forms on my machine.My assumption is that you might have created Canvas B before Canvas A , so only when you run the form you are getting Canvas B.
So in the tree , place Canvas A ahead of Canvas B , while running you will get the Canvas A.
For moving from one block to another block you can use
"go_block()" function.
--Kiran.
|
|
|
|
|
|
| Re: Problem in blocks and canvas [message #142239 is a reply to message #142225] |
Thu, 13 October 2005 22:21 |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
In canvas B i have 2 items in a block ,
i have to execute query in that block,
the main problem is i dont know how to link that , Canvas B with canvas pl/sql coding ,
sample coding is ,
go_block(b)
exe_query;
first record ;
while trans_id is not null loop then
if trans_id =1 then
set_menu_item_property('some menu_name' ) to disable the menu item through canvas b values,,,,,
like this it will take final record and select all the menu items
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Problem in blocks and canvas [message #142260 is a reply to message #142252] |
Fri, 14 October 2005 00:05 |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
wait,
first i have one login screen (form),
if login id is valid it will call another form ,
in that form i have two canvases ,
in that 2 canvases in s datablocks canvas and another one contain varoius push buttons,
if i press various push button , the custom menu will change ,
i have to give authentication for menus ,
so, based on trans_id in the data block , the security will be provided ,
So, first enterable item in login form is user_id,
through that IN USER CANVAS (when button pressed ) i will call another procedure to provide authentication.
In that authentication
i mentioned various trans id , so i dnt know how to execute that particular query in that block ,
it doesnt disable the menus based on blocks trans id..........................
thats it
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
