meta data for this page
  •  

Export CSV data 2

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