Subject | Re: [IBO] Still Edit/Update problems when SQL contains quotes! |
---|---|
Author | Jason Wharton |
Post date | 2001-10-08T18:34:07Z |
I'll take another look at this but I though I had this problem resolved
already.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
already.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: "Lukas Zeller" <luz_info@...>
To: <IBObjects@yahoogroups.com>
Cc: "Jason Wharton" <jwharton@...>
Sent: Monday, October 08, 2001 9:58 AM
Subject: [IBO] Still Edit/Update problems when SQL contains quotes!
> 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:
> >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@...)