SELECT ... AS DATASET

Syntax

  <select_statement> AS DATASET dataset;
ArgumentDescription
<select_statement>Regular SELECT statement.
datasetName of the dataset.

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

See also:
Dataset Functions
Recreating indices 2
Using SELECT statements

back to top of page
<< FOREACH statement | IBEBlock | EXPORT AS ... INTO >>