Subject | Still Edit/Update problems when SQL contains quotes! |
---|---|
Author | Lukas Zeller |
Post date | 2001-10-08T16:58:16Z |
Hello Jason,
in September, I reported a problem (new in IBO4, was ok in IBO 3.x)
with Queries getting non-Editable when Table names are is specified
in quotes as in:
SELECT
PERSKEY,
NAME
FROM
"ZL_PERS"
You replied:
there? It now looks different now.
Before, data aware controls behaved as if the query was read-only,
now I can start editing, but when changes are posted an Exception
is raised:
"Unable to initialize default EditDSQL"
As soon as I remove the quotes, everything is fine.
As nobody else seems to be running into this problem, I assume
that nomody is quoting table names except me??? I wonder why;
my idea was that by using the quotes I can generally avoid
ANY possible name clashes with reserved words. It thought that
was a clean concept. Not that I use reserved words for
table or column names myself, but I remembered situations when
I had to port some old data where changeing names were not
an option.
For my current work, I can omit the quotes if the problem
is not minor to fix in IBO.
Regards,
--
Lukas Zeller (luz@...)
-
Synthesis AG, Sustainable Software Concepts
info@..., http://www.synthesis.ch
in September, I reported a problem (new in IBO4, was ok in IBO 3.x)
with Queries getting non-Editable when Table names are is specified
in quotes as in:
SELECT
PERSKEY,
NAME
FROM
"ZL_PERS"
You replied:
>I found the problem and it will be fixed in the next subrelease.I now have downloaded IBO 4.2 Eg. Is this bug supposed to be fixed
there? It now looks different now.
Before, data aware controls behaved as if the query was read-only,
now I can start editing, but when changes are posted an Exception
is raised:
"Unable to initialize default EditDSQL"
As soon as I remove the quotes, everything is fine.
As nobody else seems to be running into this problem, I assume
that nomody is quoting table names except me??? I wonder why;
my idea was that by using the quotes I can generally avoid
ANY possible name clashes with reserved words. It thought that
was a clean concept. Not that I use reserved words for
table or column names myself, but I remembered situations when
I had to port some old data where changeing names were not
an option.
For my current work, I can omit the quotes if the problem
is not minor to fix in IBO.
Regards,
--
Lukas Zeller (luz@...)
-
Synthesis AG, Sustainable Software Concepts
info@..., http://www.synthesis.ch