Subject | Re: [IBO] TIBOTable and field names that require quoting. |
---|---|
Author | Geoff Worboys |
Post date | 2006-09-27T02:33:41Z |
>>> But the SQL generated doesn't account for the quoting on...
>>> the fields
>>> ...
>>> SELECT ALL SCHED$.*
>>> FROM SCHED$
>>> WHERE SCHED$."Acc ID" = ? /* Acc */ ID
>>> AND SCHED$."Serv ID" = ? /* Serv */ ID
>>> ORDER BY SCHED$."Acc ID" ASC
>>> , SCHED$."Serv ID" ASC
>>>
>>> What release of IBObjects?
>>>
>>...
>> 4.6.B, according to the Object Inspector, but now that you
>> mention it, this isn't a pristine version.
> As you can see, they're fairly minor.The changes you posted dont seem to effect the construction of
master/detail parameters.
In my native (TIB_*) component applications I have quite a lot
of quoted table and field names and I have not come across the
problem since Jason made a fix for me in 4.6A.
Here is an example of one from my apps (IBO v4.6.Aa), as
captured from the SQL Monitor (direct copy-n-paste):
SELECT * FROM "JT-Contact History"
WHERE "JT-Contact History"."Contact OID"=? /* "MLNK_Contact OID_0" */
ORDER BY "Timestamp" DESC
You can see that IBO successfully managed the quoted table and
field names in this instance.
Notice that the comment marker includes "MLNK_" - indicating it
is an automatically generated master link parameter. You have
not included the same in your reported problem... that makes me
wonder what you have set up for your detail dataset. Are you
using MasterLinks or MasterParamLinks etc.
I also wonder if there is any chance that your terminating '$'
on the table name could be causing a problem to some part of
IBO's name parsing.
I have not done much with IBO v4.6.Bc yet - until Jason works
out how to parse aliases out of real joins (only does old-style
joins at the moment) it is not really usable for me.
--
Geoff Worboys
Telesis Computing