OraFAQ Forum: Forms » how change the where clause in block?

Home » Developer & Programmer » Forms » how change the where clause in block? (ora10g,form10g)

Mon, 14 July 2008 01:29

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi
I want to change dynamically the "Where" clause in Block properyty.

Im using like below is it correct?

Set_block_property('statemaster',default_where,'statecode = :Statecode');

kanish

Mon, 14 July 2008 01:44

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

Senior Member
Account Moderator

Yes, it is correct in the terms of successful compiling.

No, it won't do what you'd like it to. I believe you need something like

Set_block_property('statemaster', default_where, 'statecode = ' || :Statecode);

Mon, 14 July 2008 01:53

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Thanks I got it

kanish

Previous Topic:	INSERT IMAGE IN 10G DATABASE
Next Topic:	How to delete the record ?

Goto Forum:

]

Current Time: Mon Feb 03 06:47:36 CST 2025