Fetch first 1 Rows only does not work in this Version

Avatar
  • updated
  • Completed

 Hi, in the actual Version (2.9.6.6) of SQL Query the following SQL Statement does not work:


SELECT * FROM WHERE = 'VERT01'   
fetch first 1 rows only


It comes up with an Error that the Keyword FETCH is not expected.



In an older Verion (2.7.14.0) this sql Statement works without problems.


Can you give me help on this one?

Avatar
Boris Rath

One additional Info.

If i execute the SQL in Excel with the same ODBC DNS it works.


So it seems its something in Flyspeed SQL QUERY

Avatar
Boris Rath

 No Suggestions?

Avatar
Anonymous

Dear Boris,


Thank you for your bug report. We'll fix this problem in the next build.

Avatar
Anonymous

Hello,

i have just installed the latest build (2.9.6.12)

and the Bug is still not fixed :(



Avatar
Anonymous

The bug is fixed in version 2.9.6.13. Sorry for keep you waiting for so long.

Avatar
Boris Rath

Hi,

i saw that you fixed the bug in your latest Version.

Unfortunately it is still not correct.

I do not get the error message now, but the "fetch first 10 rows only" statement does not have any effect now.

I just get all Rows of the Table to the resultset. :(


As i said before, in Version 2.7.14.0 this works correct.


Please fix this bug in your fix :)

Avatar
Anonymous

Thank you. The fix is fixed now :)

Avatar
Boris Rath

Thank you, It works as expected now.