How do I retrieve max_length from the following sql query SHOWFIELDS FROM tblX

Thu Oct 18 06:00:52 CDT 2007

Looked for an hour then 30 seconds after my post:

show_properties
    |	SHOW PROPERTIES 
    |	SHOW PROPERTIES OF DATABASE
    |	SHOW PROPERTIES OF TABLE table_name
    |	SHOW PROPERTIES OF FIELD column_refernce
    |	SHOW PROPERTIES OF LINK link_name
    |	SHOW PROPERTIES OF SERVER
    |	SHOW PROPERTIES OF CONNECTION

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Barry G. Sumpter
Sent: Thursday, 18 October 2007 8:57 PM
To: 'Valentina Developers'
Subject: How do I retrieve max_length from the following sql query
SHOWFIELDS FROM tblX

How do I retrieve max_length from the following sql query:
SHOW FIELDS FROM tblX

Its not one of the field attributes returned.

Thanks

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina