Subject RE: [IBO] IB_Query/SP/KeyLinks
Author Helen Borrie
At 10:08 PM 29/10/2004 +1000, you wrote:

>this all sounds fine.
>Do you know what difference it would make to IBO to have
>FIELD1=FIELD1
>as opposed to
>FIELD1=Mast.FIELD1
>?

Most of the time it doesn't seem to make any difference. However, when IBO
encounters an ambiguous situation that it can't figure out from the field
and param names alone, it can go a level "outward" and consider the table
qualifiers, if they are present.

>The former works fine operationally. It does not always throw a cursor
>unknow error. Only when trying to close the application.
>Maybe something in IBO is firing when the application is closing but before
>the query has closed.

Maybe. Or maybe you are in one of your ambiguous many:many conditions
that, according to you, are AOK. Still, I'm not willing to go there. I say
that a detail can have only one master and you deny it, so there's really
no other place to go on this issue.

Helen