|Subject||Re: [IBO] Editing a JOIN|
> I think missing Comma between two inline selects is a typo only.Yes I just simplified the sample
> Anyway, if you use your column A in OrderingItmen as number (in your case 4)Yes that was what I was missing, or at least I had it wrong.
> ordering should work.
There is an interesting little 'bug' where the default
column numbers start from 0 rather than 1. So when the AS A
was left out the default name became COLUMN13 ( in the real
code ) but I should have been using 14 as I had miss counted
> If you use same inline selects for your where clause instead of A thenNot sure on this one? Once the OrderingItem was set to the
> searching should working, too (at least to me, cause I use this contruct
> very often).
correct number, then both ordering and searching worked
fine. I'm talking about the native search here.
L.S.Caine Electronic Services