Subject Re: [ib-support] Re: Indices and views
Author Helen Borrie
At 10:50 AM 12-07-02 +0200, you wrote:

>Weird, isn't it? Seems this is one for the IB/FB gurus.
>BTW, I hope Helen will switch on her computer before she
>furnishes the rest of her new home :-)

Haha, someone else who appreciates my priorities. :-) The first thing I do
is assemble my bed. The next is to find and start the coffee. The next is
to set up one computer for Internet access. And now, I have almost
finished setting up the network. Now, to find out whether the cooker works...

I'm not up to score with your problem - but that message seems to appear
when you have conflicting indexes, or a query which conflicts with the
primary key. Do you, for example, have an ORDER BY DESCENDING clause on
the PK column? Or a multi-column join involving the PK column? I'll look
back and see whether you supplied the SQL...if not, please do.

>PS: Anyway, I tried to use the dummy WHERE clause, but the result
> was still the same.

The dummy WHERE clause is only useful when you want to eliminate the use of
a particular index.


All for Open and Open for All
Firebird Open SQL Database · ·