[galt]

Ah, the rigors of design debates...

First off, your requirement to have a post for a thread seems fine, and I can certainly do that, I just need to figure out the timing within the system I am developing.

As far as designs being lousy, in the "delete" issue I am referring to code design, not system design. A program should NEVER crash IMHO when it gets unexpected data or encounters database inconsistencies. Parent-child relationships can get messed up for a variety of reasons in any database that does not enforce referential integrity. There is nearly always a better response than crashing, usually to ignore it and move on. But I will be happy to revisit this debate-issue when I have fixed MY hack-bug. Some inconsistencies SHOULD be fatal, I just do not think (based on my current understanding) that this should be one of them.

I support this conclusion by the fact that I was able to post replies to this thread, and it only crashed when I tried to change the thread title. Apparently, lack of any posts was not so disturbing to the system, just this particular piece of code. I might be wrong, some of my testing was pretty late at night.

As far as "open" being a bad variable name, open is a keyword in quite a few of the languages I have worked in. It could reasonably be co-opted as a keyword in PHP version 9. There may also come a day when someone rewrites vB (or just writes some extensions or objects for it) in a new (not PHP) language where open IS a keyword. Since it is buried in the database, this will require an unnecessary variance between the PHP database and the (new language) database. You can see where this might lead. if jelsoft is the one to do it, they could make the databases consistent but would have to do some (significant?) code changes to the existing system. And this database change cascades into hacks and extensions written by other people.

Thanks firefly for the quick and clear response. Please don't take my comments as criticism, but more in the nature of good-hearted debate. As Jelsoft opens its system and more people incorporate it into other systems, you will no doubt encounter other opinions wiser than my own.