OraFAQ Forum: Forms » Quotes and Variable Values

Home » Developer & Programmer » Forms » Quotes and Variable Values

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

Quotes and Variable Values [message #86447]

Thu, 30 September 2004 09:52

Steve
Messages: 190
Registered: September 1999

Senior Member

Im trying to pass values from forms to reports and the retarded nature of Oracle systems of course, stands in my way as usual.� Is there anyone out there that can tell me how to INCLUDE QUOTES when passing a value.... eg: The following is part of a WHERE clause

I want my SQL statement to look like this:

parameter_value�= 'account_num'

Currently, it looks like this:

AND &p_use_query

So in Forms, I need to make a statement like:

:PARAMETER.p_use_query := 'table_alias.column_name = 'user_selected_value''.�

My problem is how do I include those quotes in the value being passed?� I've tried the single double single concatonation trick and that does NOT work, so please offer something that might actually help out.� Thanks.� I'm in Forms/Reports 6i.

Report message to a moderator

Previous Topic:	set password on a radio button in FORMS
Next Topic:	Himanshu can u tell me how to transfer char data in .xls file from form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:22:17 CDT 2024