Re: refering form objects in Pl/SQL

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