<< Export CSV data 1 | IBEBlock | Creating a script from a Database Designer model file >>

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