database field names with underscores about openradtool HOT 2 CLOSED

From the manpage:

Objects are generally named by an identifier.  These are always case-
insensitive alphanumeric non-empty string beginning with a letter.  There
are many disallowed or reserved identifiers.  There are also unique name
constraints to consider (e.g., no two structures can have the same name,
etc.).

The reason I disallow all but alphanumerics is because I need to uniquely recombine names when creating language-specific output. For example, I might create the C variable has_foo. It's easier to disallow the underscore than always detect whether it's prefixed by has_.

Yes, this is a little heavyweight---but I figured I'd start restrictive, then open things up as I understand the system better later!

from openradtool.

Sorry I missed that in the man page; I changed my fields to remove underscores.

BTW, I also had a field called date, which sqlite3 require you to put in quotes, which also is not supported. But that's not the smartest field name. ;)

from openradtool.