"having" keyword not syntax highlighted

[Rémi]

Hi,

First, I'd like to thank the authors of sqlite administrator for making their software publicly available for free.

I also write this message to let you know that the "having" keyword is not syntax-highlighted in the SQL editor. I suppose it should be.

(I am using 0.8.3.1 public beta)

Rémi

[Orbmu2k]

Iam not sure how to use the "having" keyword but i will consider this in the next version

[Rémi]

Iam not sure how to use the "having" keyword but i will consider this in the next version

Thanks. "having" is a kind if "where" that filters results after "group by":

Code: Select all

select poster_id, count(message_id)
from who_posted_what
group by poster_id
having count(message_id) > 2

Rémi

[Orbmu2k]

very nice ... ive wished me something like this a lot of times