Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: Problem with DatabaseMetaData.getTables and hyphenated db names


The sql that is being executed is not mine: it's what InstantDB uses to
implement the DatabaseMetaData.getTables method.  This means I cannot check
and embed anything it's doing in quotes.

Is the problem that hyphens are not "allowed characters" in names?  Is this
in the docs somewhere?  I did look, but didn't find any mention.  Maybe
there should be a section outlining allowable names for databases and
database objects?

Also, if the hyphen is not allowed, imho, InstantDB should throw an
exception if you specify a database name containing hyphens.

Regards,
Bill Graham

----- Original Message -----
From: "Tom Ngo" <tngo@waterford.org>
To: <instantDB@enhydra.org>
Sent: Wednesday, January 10, 2001 8:10 AM
Subject: Re: InstantDB: Problem with DatabaseMetaData.getTables and
hyphenated db names


> i usually replace hypens with double quotes.  depending how you set up
your
> field, if you put the fields as char, usually inserting char requires
'tim' with
> hypens to work.  Thus any name or words that may have character, you
should check
> and replace it with double quotes, then replace it back when you query it.
It is
> a simple check.
>
>
>
>
> Luke Lonergan wrote:
>
> > > If I do a DatabaseMetaData.getTables call on a database
> > > with a hyphen in the name, I get an error.  I set
> >
> > I also get errors with a hyphen in the DB name. I stopped putting
hyphens in
> > DB names...
> >
> > Luke
> >
>
> --------------------------------------------------------------------------
---
> > To unsubscribe from this mailing list, send email to
majordomo@enhydra.org
> > with the text "unsubscribe instantdb" in the body of the email.
> > If you have other questions regarding this mailing list, send email to
> > the list admin at owner-instantdb@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.