Fetch first 1 Rows only does not work in this Version

Avatar
Boris Rath
  • 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?

Replies 8
Avatar
0
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
0
Boris Rath

 No Suggestions?

Avatar
0
Anonymous

Dear Boris,


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

Avatar
0
Anonymous

Hello,

i have just installed the latest build (2.9.6.12)

and the Bug is still not fixed :(



Avatar
0
Anonymous

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

Avatar
0
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
0
Anonymous

Thank you. The fix is fixed now :)

Avatar
0
Boris Rath

Thank you, It works as expected now.


Customer support portal powered by UserEcho