Export CSV data - another example
execute ibeblock
as
begin
ExportOptions = 'OmitCaptions;
QuoteStrings;
ExportTextBlobs;
DateTimeFormat="dd-mm-yyy hh:nn:ss";
DateFormat="dd-mmm-yyyy";
TimeFormat="hh:nn:ss";
CurrencyFormat="£0.00";
IntegerFormat="0";
FloatFormat="0.0000";
Delimiter=","';
select * from clients order by cl_key as dataset MyDataset;
ibec_ds_Export(MyDataset,__etCSV,'c:\TestExport.csv',ExportOptions);
close dataset MyDataset;
end
See also:
ibec_ds_Export
EXPORT AS ... INTO
<< Export CSV data 1 | IBEBlock | Creating a script from a Database Designer model file >>







