Re: [mdb-dev] query trouble

[Michael W. <mw...@ic...>]

On Sun, Jun 13, 2004 at 09:39:49PM -0400, Jon Dixon wrote:
> I have a database I need to access that has hyphens in the middle of
> some of the table names, ie Members-Personal.  If I try:
> SELECT * FROM Members-Personal
> I get parse error at the '-' (not unexpected).
> However, if I try quoting the table name with single quotes I get
> parse error near 'Members-Personal'.
> (SELECT * FROM 'Members-Personal')
> It also fails to work with double quotes.
> 
> This occurs both using gmdb2 and with mdb-sql.  In both cases I can
> get a list of the tables, including the hyphenated ones.  In gmdb2 I
> can even use the Data button under tables to view the data.  But I
> can't get a query to work.
> 
> Is there something I'm overlooking here?

MS Access uses "[" and "]" to quote things.  I haven't tried this, but
maybe mdbtools does too.

-- 
Michael Wood <mw...@ic...>