OraFAQ Forum: Forms » code behind trigger

Home » Developer & Programmer » Forms » code behind trigger (Oracle Form Builder 10g, Win XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

code behind trigger [message #499799]

Wed, 16 March 2011 04:39

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

I have written following code behind when button pressed trigger but it is not working

go_block('block02');
query01 := 'where JLS_REQUESTS_MASTER.DIWAN_YEAR = :BLOCK01.DIWAN_YEAR
AND JLS_REQUESTS_MASTER.JALSA_SRL = :BLOCK01.JALSA_SRL
AND JLS_REQUESTS_MASTER.DIWAN_CODE = :BLOCK01.DIWAN_CODE
and jls_requests_master.qid = 28463401272';
set_block_property('block02', default_where, query01);

execute_query;

Report message to a moderator

Re: code behind trigger [message #499801 is a reply to message #499799]

Wed, 16 March 2011 04:44

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

All those "YEAR = :BLOCK.YEAR" must be modified to concatenation, such as

'YEAR = ' || :BLOCK.YEAR || ' AND JALSA = ' || :BLOCK.JALSA

Report message to a moderator

Re: code behind trigger [message #499808 is a reply to message #499801]

Wed, 16 March 2011 05:05

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

thank you for your reply but i was making mistake in writing the matching column of database. it is not 'jls_requests_master.qid', it is 'jls_requests_master.qid_no'

Report message to a moderator

Previous Topic:	Calender(Date Picker) in Form6i
Next Topic:	Can i execute the query on datablock on sametime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 13:07:55 CDT 2024