I have a PHP application that imports data from a Tab Delimited text file.
I need to validate that the text file is correctly formatted (ie. Has the
correct number of elements per line, that elements are 'reasonable' - e.g.
that a column expecting a Date gets data that is in a Date format, etc.).
I'm importing this data into a Firebird table.

In order to be able to validate the text information in the file to import,
I'd like to know the field types of each column in the table. The number of
elements per line in the text file matches exactly with the number of
columns in the table.

How can I query the Firebird database (this is in 1.5) and get back the
column names and field types, so I can validate the text file for the
import?

Myles

============================
Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
Scottsdale, Arizona USA
www.techsol.org
Phone +1-480-451-7440

Try our new Outlook Utility 'Split Personality'
http://splitpersonality.techsol.org