Re: Forms 5 programming

You want something like that:

declare
  n number;
begin
 n := to_number(:text_item);
exception
 when value_error then
 It wasn't number;
end;

Iff

Paul Q <paulq_at_home.com> wrote in message news:lLTf3.11074$_A4.213885_at_news2.rdc1.on.home.com...
> the function you are looking for is chr()
>
> wozi wrote in message ...
> >I have the following on a form:
> >1 text item
> >1 display item
> >1 pushbutton
> >
> >In the text item, users will type in either lastname or customer ID
> > JAMES
> >0120456
> >
> >If the user clicks on the pushbutton, I want the display item to indicate
> >whether
> >the data that was type in the text item is a name or a 'number'.
> >If it is a 'number', I am going to eventually convert it to a number and
do
> >a search with it.
Received on Mon Jul 05 1999 - 09:54:24 CEST