Cursor.EOF

Syntax

function Cursor.EOF(Crsr: pointer): boolean

Alternative Names

Description

Checks the cursor Crsr to see if it's at "end of file", meaning no more rows are available and returns TRUE if this is the case, 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