Re: declare a cursor!

From: jeffy <u8731305_at_cc.nkfu.edu.tw>
Date: Mon, 20 Dec 1999 13:21:55 +0800
Message-ID: <83ke58$70i$1_at_news.nsysu.edu.tw>


 hi narayan:

    Below is a sample of declare a cursor and use on button1's event.     My question is if i want to use the cursor "data" the same on button2's event,

          i don't know how to do. Could you tell me methods? thanks!

Jerry

    declare

       cursor data is
          select no,name from test;
    begin
       open data;
       fetch data into :text1,:test2;

    end;

narayan <narayan_raykarNOnaSPAM_at_engineer.com.invalid> wrote in message news:06bb3368.c9dca7cb_at_usw-ex0107-049.remarq.com...
> In article <83f159$nfu$1_at_news.nsysu.edu.tw>, "jeffy"
> <u8731305_at_cc.nkfu.edu.tw> wrote:
> > hi:
> > if i want to declare a cursor that i can use at all of form,
> > how can i write code? i use form45 to develope my program.
> > thanks!
> > Jerry!
>
>
> hi jerry,
> u might already know that u can use a cursor in forms45 in same way as
> u use in SQL*PLUS.
> but can u b more outcomming and clear on what u mean by
>
> "declare a cursor that i can use at all of form"
> bye
> narayan
>
>
>
> * 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 Dec 20 1999 - 06:21:55 CET

Original text of this message