
Adding Tables and Fields to an existing database
My employer is always asking me to add a field here or a field there. Now
the way I've been doing these additions is by having a function like, for
example 'AddEmail' to add an email field. The function would try to add
the field, if it exists and error is created so the funtion quits. So if
it does't generate an error, the field is not there and it goes ahead and
creates it. This is all done at the programs startup, or when restoring a
back-up.
Since he's been asking almost every week to add fields, I'll amassed a
horrible collection of these little functions. It looks messy and confusing
to read.
Is there an easier way to add fields to a database...at startup. The same
way from tables.
Also, a text field's character size cannot be changed at runtime, can it?
If it can, how?
Thanks....alot!
Jeff