 HELP PLZZZ [message #306558] |
Fri, 14 March 2008 12:37  |
sara110
Messages: 17
Registered: October 2007
|
Junior Member |
|
|
Hi All,
Using form 9i I want to process some data within the form. I have 3 database blocks with same query source and each of them are placed in different tabs. I am supposed to use one procedure which has 4 parameters 2 of them are in and 2 of them are out .after calling this procedure and execute query to filter data useful for each tab I have put one condition inside where clause of each block.
First question :can I put more than one condition in where clause?
second question : I have to have one more condition which is equability of OUT parameter of procedure with one of my column of datablock.If I just add this parameter which being define as global at where clause..it raise an error that this variable is invalid
Any suggestion?
Regards,
Sara
[Updated on: Fri, 14 March 2008 19:48] Report message to a moderator |
|
|
|
| Re: HELP PLZZZ [message #306697 is a reply to message #306558] |
Sat, 15 March 2008 22:39  |
sara110
Messages: 17
Registered: October 2007
|
Junior Member |
|
|
Let me ask my question one by one.
I have 3 different blocks but all of them shares same source of data (table) but they will be in 3 different page of tab canvas according to their type . for example if the typ in('G','R') all data goes to first page of tab and if typ is 'F' then it goes to second page else in third page currently when i execute the query it just display in first page and it doesnt display any data in others.I have already put this condition ie(typ) in where clause in block level so by default should filter data for each block
thanx in advance
[Updated on: Sat, 15 March 2008 23:12] Report message to a moderator |
|
|
|
| Re: HELP PLZZZ [message #306812 is a reply to message #306558] |
Sun, 16 March 2008 23:32 |
nazar400
Messages: 4
Registered: March 2007
Location: UAE
|
Junior Member |
|
|
you may have to add this code in when_new_form_instance
go_block('block1');
execute_query;
go_block('block2');
execute_query;
go_block('block3');
execute_query;
because the form acts in the fist block
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
