OraFAQ Forum: Forms » using parameter for partition name in where clause & partition name in query data source name pr

Home » Developer & Programmer » Forms » using parameter for partition name in where clause & partition name in query data source name pr

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

using parameter for partition name in where clause & partition name in query data source name pr [message #282034]

Tue, 20 November 2007 08:56

nasir_mughal
Messages: 122
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.

Report message to a moderator

Re: using parameter for partition name in where clause [message #282097 is a reply to message #282034]

Tue, 20 November 2007 20:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

partition name in query data source name property [message #282209 is a reply to message #282034]

Wed, 21 November 2007 03:18

nasir_mughal
Messages: 122
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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 22:02:42 CST 2025