Subject Re: [IBO] TIBOTable and field names that require quoting.
Author Geoff Worboys
>>> But the SQL generated doesn't account for the quoting on
>>> the fields
>>> ...
>>> WHERE SCHED$."Acc ID" = ? /* Acc */ ID
>>> AND SCHED$."Serv ID" = ? /* Serv */ ID
>>> , 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