OraFAQ Forum: Forms » Forms

Home » Developer & Programmer » Forms » Forms - Datablock

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

Forms - Datablock [message #87034]

Wed, 01 December 2004 03:40

Scoodels
Messages: 8
Registered: November 2004

Junior Member

Hi !!

I have a problem in FOrms accessing datablocks.
I have a datablock ,security_exchanges and am trying to acess its item hc_name. I suppposed to key in any value in the item and get results based on that. Suppose u want to retrieve data where he_name is USA, the above code is working if I give full name like USA, but not US. But if u see in the code, I 've used like clause.. am not sure whats happening.
could any one help me out in this.

CASE
WHEN :security_exchanges.he_name is not null THEN
v_where := 'where he_name like '||''''||
:security_exchanges.he_name||'%'||'''';

Thanks
scoodels

Report message to a moderator

Re: Forms - Datablock [message #87036 is a reply to message #87034]

Wed, 01 December 2004 04:00

Adi
Messages: 38
Registered: May 2002

Member

'where he_name like '||''''||
:security_exchanges.he_name||''%''||'''';
just see the chang and use this

Report message to a moderator

Re: Forms - Datablock [message #87037 is a reply to message #87036]

Wed, 01 December 2004 04:06

Scoodels
Messages: 8
Registered: November 2004

Junior Member

no I wont work either..actually if u put double quotes it wont compile.

I am thinking whether we should not use where clause for databock items. Its not control block. IS that the oracle is not able to figure two where clauses.. its default where and the where for data block. should we not use where to acess data block. pls, help me out.

Thanks

Report message to a moderator

Previous Topic:	Update Or Refresh the same field in two forms
Next Topic:	What is the possible trigger which can fire at the time of posting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 05:45:15 CDT 2024