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

> -----Original Message-----
> From: Woody (TMW) [mailto:woody.tmw@...]
> Sent: Friday, 2 May 2003 2:35 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] getting field type
>
>
> > Hi
> >
> > I have been able to get all the table names in a DB using
> > (interBaseExpress):
> >
> > .GetTableNames
> >
> > Also for each table I can get the fields using:
> >
> > .GetFieldName
> >
> > But how can I get the field type (Varchar, INteger, etc)
> >
>
> You should actually use the Borland newsgroups to ask IBX questions.
> However, in general, for any dataset in Delphi, use the FieldKind property
> of the specific field to get the type of data it contains. If you want a
> more accurate view of data types, you will need to read the system tables.
>
> Woody (TMW)
>
> "Start every day off with a smile and get it over with."
> -- W. C. Fields
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>