Home » Developer & Programmer » Forms » HELP PLZZZ
icon9.gif  HELP PLZZZ [message #306558] Fri, 14 March 2008 12:37 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: HELP PLZZZ [message #307361 is a reply to message #306812] Tue, 18 March 2008 10:40 Go to previous message
sara110
Messages: 17
Registered: October 2007
Junior Member
thanxx for your reply..
yap I added that one.It's ok now
Previous Topic: How to call .ppt file --> 10g forms
Next Topic: text fields assignment
Goto Forum:
  


Current Time: Thu Dec 08 22:19:56 CST 2016

Total time taken to generate the page: 0.06949 seconds