OraFAQ Forum: Forms » Casting single letter as char(1)

Home » Developer & Programmer » Forms » Casting single letter as char(1) (Forms 6i)

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

Casting single letter as char(1) [message #351080]

Mon, 29 September 2008 04:10

didiera
Messages: 134
Registered: August 2007
Location: Mauritius

Senior Member

Hello again,

I wanted to know if it were possible for me to retrieve a single letter from a varchar field into a char field of lenght 1. I have been around and tried CASTing and though in PL/SQL it's ok, it doesn't compile in forms 6i stating that expression is of wrong type the code actually looks like this :

select nvl(my_char_field,cast(substr(my_varchar_field,1,1) as char))  from my_table;

By the way what this query seeks to achieve is to replace the eventual missing values from my_char_field by the first character of my_varchar_field... but type casting screws up; maybe because it's Forms 6i?

regards,
DIdz

Report message to a moderator

Re: Casting single letter as char(1) [message #351117 is a reply to message #351080]

Mon, 29 September 2008 06:15

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

Senior Member
Account Moderator

I'm unable to test it, but - wouldn't simple

:block_name.your_char_item := substr(:block_name.your_varchar_item, 1, 1);

do the job, even without casting?

Report message to a moderator

Re: Casting single letter as char(1) [message #351201 is a reply to message #351080]

Mon, 29 September 2008 18:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I thought Forms only had tiems of typer 'char'. There is no 'varchar' in the Data Type list.

David

Report message to a moderator

Re: Casting single letter as char(1) [message #351211 is a reply to message #351201]

Mon, 29 September 2008 22:30

didiera
Messages: 134
Registered: August 2007
Location: Mauritius

Senior Member

Hello Martin,

well I use Forms6i and I actually use varchar strings, you even have varchar2 type. But anyway don't bother with that post. I have found some workaround anyway.

thanks everyone
Didz

Report message to a moderator

Re: Casting single letter as char(1) [message #351221 is a reply to message #351211]

Tue, 30 September 2008 00:27

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

My name is 'David'. It is the name that I place at the end of all of my posts.

David

Report message to a moderator

Re: Casting single letter as char(1) [message #351286 is a reply to message #351221]

Tue, 30 September 2008 04:02

didiera
Messages: 134
Registered: August 2007
Location: Mauritius

Senior Member

my apologies David

Far from me the audacity of running a chance to get a cap in my head with your signature on the cartridge. We're cool pal?

cheers,
Didz

Report message to a moderator

Re: Casting single letter as char(1) [message #351441 is a reply to message #351286]

Tue, 30 September 2008 19:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

We're cool.

David

Report message to a moderator

Previous Topic:	[FORMS] HOW MAKE UPDATE VIEW in FORMS??
Next Topic:	Forms with Mac OS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 12:21:57 CST 2025