Subject Re: [IBO] TIBOTable and field names that require quoting.
Author Helen Borrie
At 12:33 PM 27/09/2006, Geoff wrote:
>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.

Geoff, mspencewasunavailable isn't using native IBO. The TDataset
components do master-detail linking quite differently to the way IBO
does it. "Automatically-generated masterlink parameters" for TQuery
(such as they are) use the inherited TDataset methods, which work
with internally generated TField objects and are subject to some
givens that are absent from his situation. Essentially he has no
choice but to use the explicitly parameterised query method
here. You might like to review what I wasted my time on for nearly
an hour last night on this thread.