OraFAQ Forum: Forms » Reports in Forms 10g

Home » Developer & Programmer » Forms » Reports in Forms 10g (D2k Forms,10g, windows 7, Firefox)

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

Reports in Forms 10g [message #595662]

Thu, 12 September 2013 12:20

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

In Push button I written this code...
It was working properly..
I used this

[b]dptno='||''''||:dept.deptno||'''')[/b]

in the below code....
But what is the use of

 ''''

?

Any one please explain.....

..
SET_REPORT_OBJECT_PROPERTY(v_repid,REPORT_OTHER,'paramform=no dptno='||''''||:dept.deptno||'''');
...

Thanks
The Learner.

Report message to a moderator

Re: Reports in Forms 10g [message #595670 is a reply to message #595662]

Thu, 12 September 2013 13:17

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Does this offer any help?

SQL> l
  1* select 'paramform=no dptno='||''''||sysdate||'''' from dual
SQL> /

'PARAMFORM=NODPTNO='||''''||SY
------------------------------
paramform=no dptno='12-sep-13'

Report message to a moderator

Re: Reports in Forms 10g [message #595687 is a reply to message #595670]

Thu, 12 September 2013 13:55

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If too many single quotes look horrible, you could always use CHR(39) and concatenate it with your values, such as

SQL> select 'paramform=no deptno=' || chr(39) || sysdate || chr(39) from dual;

'PARAMFORM=NODEPTNO='||CHR(39)||
--------------------------------
paramform=no deptno='12.09.2013'

SQL>

Report message to a moderator

Previous Topic:	Refresh Problem
Next Topic:	multiple sort options

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:44:56 CDT 2024