At 13:32 2018-04-19, Ted Roche tedroche@gmail.com wrote:
[snip]
Unsurprisingly, ODBC thinks it's a dumb name for a field, too.
You'll probably need to "escape" it. I'm decades out of ODBC, so I don't recall if ODBC wants you to enclose the field name in single quotes, square brackets or back ticks (that `` funny key in the upper left corner no one ever uses). A web search might yield a suggestion, or you can just try the Usual Suspects...
Or maybe double-quotes. Or maybe, doubled single-quotes (like ''this''). Or maybe escaped quotes (of various sorts) such as '"'.
Isn't it nice to have options? <GD&RVVF>
That funny key is used in UNIX.
Sincerely,
Gene Wirchenko