Subqueries and LIMIT not supported :-)

[Gary Kahrau]

SELECT help_keyword_id, name
FROM help_keyword WHERE help_keyword_id NOT IN
(SELECT help_keyword_id FROM help_keyword ORDER BY help_keyword_id LIMIT
10) ORDER BY help_keyword_id LIMIT 10

But the underlying db versions 4.1 and 5.0.4 beta do not support the above command. The engine returns the following error message:

This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

In VS 2005 the datagridview control supports virtualmode.

MS SQL 2000 and 2005 supports the command to do the paging.

Are there any plans to fix this?

Gary Kahrau
Vice President - Stellex Monitor Aerospace
Phone: [phone] Fax: [phone]
[e-mail]