Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: refering form objects in Pl/SQL

Re: refering form objects in Pl/SQL

From: Olga Greep <olga_at_hi.nl>
Date: Mon, 13 Mar 2000 19:04:24 +0100
Message-ID: <8ajamd$45nb5$1@reader1.wxs.nl>


Hi,

Although I do not really understand what you want to do, I guess this should help you get rid of your error

begin
select bal into :bal from accounts
where account_id = 3;
end;

:bal refers to the field in your form named bal that is in the current row, the row with imput-focus

good luck

Olga Greep

saf wrote in message <184874d0.6d5559f5_at_usw-ex0107-049.remarq.com>...
>hi,
>me a novice..
>i've got a form with a one text item(Balance:name'bal') and a
>button(Show balance).
>When the button is pressed the text item should display the balnce of
>account_id 3....this is what i have done:
>
>
>begin
>select bal into 'bal' from accounts
>where account_id = 3;
>end;
>
>when i compile it it gives e error saying:
>simple name required in this request.
>
>ANyone please...anyone
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Mar 13 2000 - 12:04:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US