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 >>