Login

    Register

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.
Managed Hosting

PROJECT CATEGORIES

 

DBX
Project Home Forums Known Issues Screenshots External Project Link Contact Project

DBX Issue: SQL*EXEC window prefills column and database names without brackets

Name: SQL*EXEC window prefills column and database names without brackets
ID: 5
Project: DBX
Type: Bug
Area: Code
Severity: Normal
Status: Fixed
Related URL:
Creator: Donald Langhorne
Created: 11/16/08 9:47 PM
Updated: 11/18/08 11:20 AM
Description: First off, GREAT product. Very impressive.

I found when I was editing a view that was called 'Accounting Details' that when I clicked on 'SQL*EXEC' link it opened the popup window and prefilled the query for that view, however when I ran it I got an error, after inspecting the error and the sql, it was self-evident that the view name was not enclosed in brackets.

I personally avoid tables and columns with spaces in them, but for the product I am using, we do use views and column names that are "friendly", which almost always means spaces.

In my own coding, I find if I always enclose columns and tables with brackets [] I can avoid this pitfall...

Thanks!

Don Langhorne
History: Created by dlangh (Don L) : 11/16/08 9:47 PM

Updated by websolete (Kevin Miller) : 11/18/08 11:20 AM
Column names are now [bracketized] when launching SQL*EXEC window from table or view details.

To add a comment to this bug, please login using the link above.

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.