Home » Developer & Programmer » Forms » how change the where clause in block? (ora10g,form10g)
how change the where clause in block? [message #333656] Mon, 14 July 2008 01:29 Go to next message
mm_kanish05
Messages: 487
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
Re: how change the where clause in block? [message #333663 is a reply to message #333656] Mon, 14 July 2008 01:44 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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);
Re: how change the where clause in block? [message #333667 is a reply to message #333656] Mon, 14 July 2008 01:53 Go to previous message
mm_kanish05
Messages: 487
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: Sat Dec 03 08:11:09 CST 2016

Total time taken to generate the page: 0.04663 seconds