Re: [Qform-general] Table names with dashes

[Dave G. <dgl...@po...>]

On Thu, 24 Jul 2003 17:51:58 +1000, "S Khan" <s_k...@ho...>
wrote:

> Dave,
> I came across QueryForm after seeing a link you
> posted to it on comp.lang.java.databases, while
> looking for info on Jakarta Commons DBCP.
>=20
> It seems like a really neat utility. I mainly work
> with MS SQL Server (using Enterprise Manager and SQL
> Query Analyzer), but I found that QueryForm makes it
> easier to do some things such as get an (ordered)
> lists of column names. I was wondering if you knew
> of any other advantages QueryForm has over using the
> MS SQL Server utilities I mentioned?

Not being familiar with those tools, it's hard to say.

>=20
> My main reason for posting however is that when I
> try to do queries on tables with - (dashes) in the
> name of the table, e.g. tablename-01, I get the
> following 'Database Error':
>=20
>=20
> The following database error occurred:
> java.sql.SQLException
> [Microsoft][SQLServer 2000 Driver for
> JDBC][SQLServer]Line1: Incorrect syntax near '-'.
>=20
> I can't rename the table since a bunch of other
> developers are working on it too. When using SQL
> Server's SQL Query Analyzer, I get round the problem
> by putting square brackets around the table name.
> But I can't find a way to edit the select SQL in
> QueryForm. Is there a way?

Attached is a copy of org/glasser/sql/TableInfo.java which should fix
your problem. I'm not going to put it into the CVS repository,
however, until I've tested it against some other databases. I haven't
tested it against SQLServer (I don't have a copy of it), but it should
work because it inserts the square brackets.

I'll send you separately (off-list) a copy of qform.jar that contains
this fix. Back up your old copy (it's in the directory where you
installed QueryForm) and copy the one I send you over top of it. The
one I send you also has some new code (yet unreleased) that lets you
change the Look-and-Feel of the program while it's running, and
install third-party Look-and-Feels. Check the "Look and Feel" submenu
in the Window menu. It's pretty cool.

Thanks for the bug report. Please let me know if this fix works.

Dave