Fog Creek Software
Discussion Board




Knowledge Base
Documentation
Terry's Tips
Darren's Tips

Database question to Fogcreek

Will CityDesk break or become inoperative if I were to add tables to a .cty file?

amos
Sunday, February 15, 2004

Nope.  As long as you don't change the existing structure it shouldn't have an effect.  Run it on a test database just to make sure first.

Michael Pryor
Fog Creek Software
Sunday, February 15, 2004

You can even add columns to existing tables.

Suggestion 1: Give your own tables and columns names that clearly flag they are not part of the Fog Creek schema.

Suggestion 2: Back up everything before you go playing with queries or forms that could alter elements of the Fog Creek tables.

David Walker
Sunday, February 15, 2004

Interesting!

Can I query my new fields with CityScript?

Bob Bloom
Monday, February 16, 2004

No. Think about this: how would CityScript know about your new fields?

John Topley (www.johntopley.com)
Monday, February 16, 2004

If you do add your own fields and tables, please try to use ridiculous names that have no chance of ever getting in the way of something fog creek puts there in the future. For example "Happy_bunny_My_Silly_Field" and the like...

For example, we always name our tables starting with "tbl" so if you name your tables "mytbl" than future versions of the CityDesk database format will never conflict.

Joel Spolsky
Fog Creek Software
Friday, February 20, 2004

*  Recent Topics

*  Fog Creek Home