ibec_ds_Sort

Sorts datasets according to the SortFields specification.

ibec_ds_Sort function sorts the specified Dataset according to the SortFields specification.

 function ibec_ds_Sort(Dataset : variant; SortFields : string) : variant;

  execute ibeblock
  as
  begin
    select * from rdb$relation_fields
    as dataset ds;
    try
      ibec_ds_Sort(ds, 'RDB$RELATION_NAME ASC, RDB$FIELD_POSITION ASC');
      ibec_ds_Sort(ds, 'RDB$RELATION_NAME, RDB$FIELD_POSITION');         
      ibec_ds_Sort(ds, '1, 2 DESC');       finally
      ibec_ds_Close(ds);
    end;
  end;