[Metakit] Mk4py

[Jean-Claude Wippler]

On Aug 4, 2005, at 18:37, Brian Kelley wrote:

> Yeah the spaces kill me as well sometimes, and then I think that the
> spaces are okay sometimes.
>
> The real issue is that a metakit column name can include any printable
> character except a comma ",".

Nor [, ], :, and a few more such as parentheses and braces which I'd  
like to reserve for new uses.  Best to stick with alphanumerics only,  
even though MK does not enforce it.  Best also to be consistent in  
the use of upper/lower case.

> So, now you know :)
>
> Here is another gotcha for you.  Never, ever delete a column and then
> add a column with the same name and a different type.  This will drive
> you bananas, I guarantee.
>
> To safely do this, delete the column, write out the db to a new file.
> delete the database, repoen it and then add the new column.

The key is the commit - that is the moment when a "deleted" column  
really goes away.  The new-file/delete/reopen approach is fine too,  
but not strictly necessary.

-jcw