Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Backtick Backquote in JDBC Driver SQL
Backtick Backquote in JDBC Driver SQL [message #57227] Fri, 10 July 2009 16:47 Go to next message
Rob C. is currently offline Rob C.
Messages: 2
Registered: July 2009
Junior Member
The SQL builder adds backticks (backquotes) to database and table names.
Teradata (which I'm accessing through a JDBC driver) can't interpret the
backquotes. Is there an way to make them optional, or replace them with
another delimiter? (Teradata uses double quotes (") or nothing instead of
the backquote (`).
Re: Backtick Backquote in JDBC Driver SQL [message #436370 is a reply to message #57227] Thu, 30 July 2009 19:12 Go to previous message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
The SQL Query Builder component uses double-quotes, so I'm surprised
that you are seeing back-quotes. Plus, it only quotes when necessary.
(That is when the identifier contains spaces or other unusual
characters.) Can you give a more detailed usage scenario?

Rob C. wrote:
> The SQL builder adds backticks (backquotes) to database and table names.
> Teradata (which I'm accessing through a JDBC driver) can't interpret the
> backquotes. Is there an way to make them optional, or replace them with
> another delimiter? (Teradata uses double quotes (") or nothing instead
> of the backquote (`).
>
>
Re: Backtick Backquote in JDBC Driver SQL [message #596171 is a reply to message #57227] Thu, 30 July 2009 19:12 Go to previous message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
The SQL Query Builder component uses double-quotes, so I'm surprised
that you are seeing back-quotes. Plus, it only quotes when necessary.
(That is when the identifier contains spaces or other unusual
characters.) Can you give a more detailed usage scenario?

Rob C. wrote:
> The SQL builder adds backticks (backquotes) to database and table names.
> Teradata (which I'm accessing through a JDBC driver) can't interpret the
> backquotes. Is there an way to make them optional, or replace them with
> another delimiter? (Teradata uses double quotes (") or nothing instead
> of the backquote (`).
>
>
Previous Topic:Access Web Services using DTP
Next Topic:"Edit in SQL Query Builder..." does nothing
Goto Forum:
  


Current Time: Fri Aug 01 18:46:41 EDT 2014

Powered by FUDForum. Page generated in 0.10795 seconds