> Woody,
> A better method (maybe ib future) is to keep a copy of the the db you
> distribute.. develop further - then when you are read you to distribute
> again, do a metadta compare which generates an update script, then send

this

> script is a new version.
> I also keep a version table in the db, at the end of the script, update

the

> version number. I also keep my update scripts in my application, then if a
> user doesn't run the app between the time I send yet another update, each
> app will run update scripts in sequence to bring the db up to date.
> Alan
>

I understand that, however, the posters question only concerned retrieving
the field types. It wasn't mentioned that they were interested in comparing
DBs or updating them.

I use a similar method for my databases. An updated script is generated and
sent out. The admin update program reads the script and performs all updates
needed in order. Each update number is stored in a table so it's never done
more than once. Initially, I wrote mine for Access databases. I am currently
trying to finish one converted to IB/FB.

Woody (TMW)

"Start every day off with a smile and get it over with."
-- W. C. Fields