Cursor.Next

Syntax

function Cursor.Next(Crsr: pointer): boolean

Alternative Names

Description

Moves the cursor Crsr to the next row, returns TRUE if successful (not EOF), FALSE otherwise.

See also

Example

execute udsblock()

returns(r_int integer, r_varchar varchar(100), r_num numeric(15, 2))

as

begin

  /* create the cursor */

  mydata = Cursor.Create('select * from UDS$TEST_DATA');

  try

    fetched_data = null;

    while not Cursor.EOF(mydata)

    do begin

              Cursor.Fetch(mydata, fetched_data, 0, Cursor.FieldCount(mydata));

     /* fetched_data array now holds data */

     r_int = fetched_data[0];

     r_varchar = fetched_data[1];

     r_num = fetched_data[5];

     suspend;

         Cursor.Next(mydata);

   end

  finally

    Cursor.Close(mydata);

  end        

end