A simple program to extract reports from simple databases

tdbodbc is a program that allows a user to extract data from any ODBC source with any SQL query and then to format it in a nice way.

The simplest usage is to export an ODBS source to a comma-delimited file:

tdbodbc mydsn "SELECT * FROM emails"

will produce this output:

"Alessandro Giordano","operator@piw.it"
"Roberto Piola","roberto@ilpiola.it"

The more sophisticate way of using it is to pass a template (or a mask) for building a file with a particular format, for example a web page:

tdbodbc mydsn "SELECT * FROM emails" mask "<A HREF="mailto:%2%">%1%</a><br>"

will produce the page

Alessandro Giordano
Roberto Piola

tdbodbc is basically an evolution of the simpler tdb program, and is available on the Windows 95/98 and NT platforms.