This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 152233 - Dialogs that refer to DB identifiers should quote automatically
Summary: Dialogs that refer to DB identifiers should quote automatically
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-03 20:22 UTC by David Vancouvering
Modified: 2013-08-01 12:52 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description David Vancouvering 2008-11-03 20:22:26 UTC 
We have a very nice utility called org.netbeans.api.db.sql.support.SQLIdentifiers.Quoter that knows when a particular
identifier needs to be quoted, providing the method quoteIfNeeded().  

We are using this when we generate select statements internally (such as with "View Data" action), but we should use
this to automatically quote identifiers in our UI dialogs.  So for example, when the user wants to create a table, the
table name and column names should be quoted automatically if they contain characters (such as spaces or multibytes)
that need to be quoted.
Comment 1 Jiri Rechtacek 2009-10-16 14:03:21 UTC 
Reassigned to new owner.