Sorts datasets according to the SortFields specification.

Syntax

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

Description

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

Example

    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;

See also:
ibec_ds_Locate

back to top of page
<< ibec_ds_SetField | IBEBlock | Working with XML data >>