Home » Developer & Programmer » Forms » SET_BLOCK_PROPERTY  () 1 Vote
icon4.gif  SET_BLOCK_PROPERTY [message #225633] Tue, 20 March 2007 11:36 Go to next message
asmani
Messages: 47
Registered: February 2007
Member
Hi everyone and good evening,

I working on a form which contains some data blocks but one of them got some non-database items, I am trying to fetch records on one of these non_datebase items by using execute_query but it fetches records but displays only in first row of the display gird. If I change the property of that data block "DATABASE DATA BLOCK" to NO then it work but rest of stuff stop working.

can we switch(yes/no) "DATABASE DATA BLOCK" property on run time.

Its bit urgent...............

[Updated on: Tue, 20 March 2007 11:45]

Report message to a moderator

Re: SET_BLOCK_PROPERTY [message #225896 is a reply to message #225633] Wed, 21 March 2007 19:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try using the Post-Query trigger to populate these non-database items.

David
icon5.gif  Re: SET_BLOCK_PROPERTY [message #226347 is a reply to message #225896] Fri, 23 March 2007 05:44 Go to previous messageGo to next message
asmani
Messages: 47
Registered: February 2007
Member
I want to make non-database item Query able.
Re: SET_BLOCK_PROPERTY [message #226894 is a reply to message #226347] Mon, 26 March 2007 19:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use a view.

David
Re: SET_BLOCK_PROPERTY [message #232831 is a reply to message #226894] Mon, 23 April 2007 08:55 Go to previous message
asmani
Messages: 47
Registered: February 2007
Member
Thanks,
I have solved that problem by using that property.

SET_BLOCK_PROPERTY('block_name',DEFAULT_WHERE,'where caluse');

note don't use varibales otherwise you may got errors.
thanks again.
Previous Topic: Request for Project!!
Next Topic: Newbie!! how do I create a trigger in my forms
Goto Forum:
  


Current Time: Wed Dec 07 08:59:10 CST 2016

Total time taken to generate the page: 0.08494 seconds