Bugs in SQL using Select Top * from example order by account_no Top is ignored.

[douglasg76]

I am interested in buying Lianja, I'm beta testing.
But I would like not to ignore the comments.
I have been testing Lianja Console vfp recital:

please fix it, SQL error, when you used order by the Top is ignored.

IN SQL Server

first reccord
select top (1) * from example order by asc account_no

last reccord
select top (1) * from example order by desc account_no

Be first Record
select top (10) * from example order by account_no

But this fails. or should integrate something like Mysql server
with Limit.

IN Mysql Server
select * from department order by asc iddepartamento Limit 1
last
select * from department order by iddepartamento desc Limit 1
Be first Record
select * from department order by iddepartamento Limit 10

[yvonne.milne]

Converted to Ticket: LIMIT working correctly, TOP <expN> and TOP (<expN>) ignored if an ORDER BY clause included. The TOP problem has been fixed and will be available in the Beta 8 Refresh 1.

[lianjasupport]

This has been fixed in beta8 refresh 1