Dataset.EOF

Syntax

function Dataset.EOF(ADataset: pointer): boolean

Alternative Names

Description

Checks the dataset ADataset 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()

as

declare variable resultbool boolean;

begin

  /* create the data set */

  select employeeid, emp_name, salary, bonus_perc

  from test_data order by employeeid

  as dataset mydata;

  try 

    resultbool = Dataset.BOF(mydata);

    Dataset.Next(mydata);

    Dataset.Next(mydata);

    resultbool = Dataset.BOF(mydata);

    Dataset.Prior(mydata);

    Dataset.Prior(mydata);

    resultbool = Dataset.BOF(mydata);

    Dataset.Next(mydata);

    Dataset.First(mydata);

    resultbool = Dataset.BOF(mydata);

    Dataset.Next(mydata);

    Dataset.Prior(mydata);

    Dataset.Prior(mydata);

    resultbool = Dataset.BOF(mydata);

    Dataset.Last(mydata);

    resultbool = Dataset.EOF(mydata);

    resultint = Dataset.RecordCount(mydata);

  finally

    Dataset.Close(mydata);

  end        

end