Buy ODBC 4 ALL Online!

Ascii Output Files & Tables

When Output Type=AsciiFile, a TAB delimited ascii file will be created.

• The TAB delimiter is the ascii char 9 (decimal) - 09 HEX
• The 1st row contains the field names.

When Output Type=AsciiTable, an ascii file containing data in a table will be created.

• 3 rows are added at the top of the file for the table's header.
• 1 line is added at the end of the file for the table's footer.
• Numeric columns are right aligned, all other columns types are left aligned.

  EXAMPLE

  +---------+---+ |Customer |Age| +---------+---+ |John Doe | 37| +---------+---+

  This output file is particularly useful to be automatically printed / faxed / converted in PDF format by our Printfil - Windows Printing System for Applications - software.

If a field on the SQL table contains the NULL value, in the ascii file you will find an empty string ("")

A DateTime field will be translated in a date + time string in the format: yyyy-mm-dd hh:mm:ss

Buy ODBC 4 ALL Online!