CLOSE DATASET

Closes an existing dataset.

Syntax

CLOSE DATASET dataset;
Argument Description
dataset Name of an existing dataset created with SELECT ... AS DATASET statement.

Example

execute ibeblock
returns (FieldName varchar(31), FieldType varchar(100))
as
begin
  select * from rdb$fields
  where (1 = 0)
  as dataset RdbFields;

  iCount = ibec_ds_FieldCount(RdbFields);
  i = 0;
  while (i < iCount) do
  begin
    FieldName = ibec_ds_FieldName(RdbFields, i);
    FieldType = ibec_ds_FieldTypeN(RdbFields, i);
    suspend;
    i = i + 1;
  end;

  close dataset RdbFields;
end