Colin


When you finally finish using your head as a battering ram and the wall falls down its quite pleasant

Roy Lambert

Life seemed simpler when if not exists existed

Colin,

<< In my app I want to include a feature where my clients can customise the
text captions for the various edit fields, as well as customising Hint
descriptions and the like.  As part of that feature I want to tell them what
type of data can be entered into each field and what the maximum field
length is.  I also want to be able to add a utility function for myself that
looks at all the fields of various tables and ensures that I haven’t created
fields that are a certain size in a table and a completely different size(or
data type) in another. >>

As Roy indicated, using the system information tables is the way to go.
They already contain nice descriptive names for the column types, and are
easily retrieved with a query.  You can find out about all of the system
information tables here in the SQL manual:

http://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=system_information

Specifically, here's the TableColumns table:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=TableColumns_Table

As for generating a table that can be edited, you can use something like
this:

CREATE TEMPORARY TABLE MyEditableStructureInfo AS
SELECT <Desired Columns> FROM Information.TableColumns WHERE <Where Clause>

--
Tim Young
Elevate Software
www.elevatesoft.com

Colin


Don't forget my other long time favourite NULL = ''


Some bits of DBISAM I still miss, and will continue to do so.


Roy Lambert