OraFAQ Forum: Forms » CASE Statement in Forms

Home » Developer & Programmer » Forms » CASE Statement in Forms (Form 6i)

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

CASE Statement in Forms [message #500844]

Thu, 24 March 2011 01:00

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

When I tried to have a Cursor with SELECT CASE statement in Forms 6i , it is not working. But the same query is working in SQL PLUS .Any Reason ? We cannot use case in Forms 6i ?

Regards,
Paules

Report message to a moderator

Re: CASE Statement in Forms [message #500885 is a reply to message #500844]

Thu, 24 March 2011 06:22

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

Senior Member
Account Moderator

Forms 6i's PL/SQL engine might be too old to support CASE, so you might need to use DECODE instead.

Or (depending on what you are doing), you might create a stored procedure (that is executed in the database, so it supports CODE) and call that procedure from your form.

Report message to a moderator

Re: CASE Statement in Forms [message #500913 is a reply to message #500885]

Thu, 24 March 2011 08:30

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

Senior Member

Littlefoot wrote on Thu, 24 March 2011 07:22

Forms 6i's PL/SQL engine might be too old to support CASE, so you might need to use DECODE instead.

Correct, 6i did not support CASE.

Report message to a moderator

Re: CASE Statement in Forms [message #500934 is a reply to message #500913]

Thu, 24 March 2011 10:04

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Hai,

Noted. Thanks for the reply.

Regards,
Paules

Report message to a moderator

Re: CASE Statement in Forms [message #500987 is a reply to message #500934]

Thu, 24 March 2011 16:30

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can also create a view for your cusor query and use that in the form.

Report message to a moderator

Re: CASE Statement in Forms [message #501119 is a reply to message #500987]

Fri, 25 March 2011 23:29

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

ok.Thanks.

Regards,
Paules

Report message to a moderator

Previous Topic:	Creating a new browser session with forms 11g
Next Topic:	Form Builder 10G Software

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 08 05:13:07 CDT 2026