> how can I get the type and the length (for example > varchar(40)) of a field? > > The SHOW COLUMNS FROM * sql query doesn't works within the ic... 8-( go to the UI and click on administration, scroll down and you'll see your list of database tables. click on one of them and it'll list the details. DC