Home » Developer & Programmer » Forms » using parameter for partition name in where clause & partition name in query data source name pr
using parameter for partition name in where clause & partition name in query data source name pr [message #282034] Tue, 20 November 2007 08:56 Go to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
hi, i am using Forms 6i, i want to know how can i use parameter for partition name in where clause of the data block's property. can any one help me.
Re: using parameter for partition name in where clause [message #282097 is a reply to message #282034] Tue, 20 November 2007 20:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'default_where'. You could also look it up in the reference manual or help facility.

David
partition name in query data source name property [message #282209 is a reply to message #282034] Wed, 21 November 2007 03:18 Go to previous messageGo to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Hi, i have created two list partitions p_2007 and p_2008 on 'year' column of 'transactions' table.

I want to use parameter for replacing partition name in 'query data source name' property of the transactions data block

like
property---------------->value
query data source name-->transactions partition (:parameter.year)

but i am getting error unable to performe query.
------------------------------------------------------
if dont use parameter for partition name

like
property---------------->value
query data source name-->transactions partition p_2007

its working

i know i can use 'set_block_propery' but i want to use paramter
plz anyone help me how can i use parameter for partition name in query data source name property.


Thanks in advance.

[Updated on: Wed, 21 November 2007 03:21]

Report message to a moderator

Re: partition name in query data source name property [message #282408 is a reply to message #282209] Wed, 21 November 2007 23:07 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please don't start a new thread for the same subject.

I suggest using the 'set_block_property' in the 'when-new-form-instance' trigger.

Have you tried 'parameter.year' without the colon?

David
Previous Topic: Cascading Problem
Next Topic: copy file from client to server in a web deployed application
Goto Forum:
  


Current Time: Tue Dec 06 15:59:07 CST 2016

Total time taken to generate the page: 0.10661 seconds