Subject Re: [IBO] TIBOTable and field names that require quoting.
Author mspencewasunavailable
--- In, Geoff Worboys <geoff@...> wrote:
> Hi Michael,
> ...
> > 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?
> I hit a similar problem and Jason has fixed it in the 4.6A
> release of IBO. So I am wondering whether that fix will have
> solved your problem or not. I have some quite similar
> queries in my apps (using TIB_* components, not TIBO*
> components) and have not hit the problem again since 4.6A.
> --
> Geoff Worboys
> Telesis Computing


4.6.B, according to the Object Inspector, but now that you mention
it, this isn't a pristine version. There were a host of other
problems which were solved by some patches I got from another poster
(Ramil [khabibr@...]) who said he'd sent them directly to Jason,
but that Jason was away at the time. See this message: "Re[2]:
[IBO] Quoted fields seem to be broken in TIBODataset when they're
involved in indexing" around 7/31/2006. I had to apply these to get
anywhere at all. While they look like fairly extensive patches, a
diff shows that they're actually only a couple of lines in a couple
of places. If it's helpful, I can produce a diff for you between
the released source and what I'm using.

I'd be surprised if these patches had any affect on the SQL that
gets generated when a master dataset is used (although I've
certainly been surprised before). I do have to apologize for the
fact that I'd forgotten that I was using a patched version but
without the patches, most of my code won't run at all. I was really
hoping they'd be included in a future version. Tomorrow, I'll try
to make time to see if I can get a little more info and maybe work
up a patch for the problem instead of just working around it. I'm
betting it's not a big deal.

Michael D. Spence
Mockingbird Data Systems, Inc.