Re: How to use last 10 characters of a 12 char field in Forms?

From: Chris Boyle <cboyle_at_hargray.com>
Date: Mon, 20 Oct 2003 21:30:37 -0400
Message-ID: <V_%kb.31164$N94.27928_at_lakeread02>


[Quoted] [Quoted] IF you only want to remove the first two charactero

myVariable := substr(:myBlock.myField);

"Richard" <itdad_at_yahoo.com> wrote in message news:367d520f.0310141926.2d20f2f9_at_posting.google.com...
> I'm new to Oracle Forms and I need help in using the last 10
> characters of a 12 character field in Forms. I looked at using a
> sync'ed field (mirrored), or a hidden database field with a text
> field, or writing some PL/SQL. I don't know the best approach.
>
> It seems that each field doesn't have events but rather the data block
> does? Is this correct? So if you write code then you must know which
> field triggered the event?
>
> Any help / ideas would be greatly appreciated.
Received on Tue Oct 21 2003 - 03:30:37 CEST

Original text of this message