Page 1 of 1

Error in "row_number() OVER" statement

Posted: Thu 16 Jul 2009 08:11
by mars
Hello,

Linq to Entity generate sql with wrong (in my opinion) fragment :

[b]row_number() OVER (ORDER BY ,"Project1".ACC_ID ASC) AS "row_number"[/b]

should be without comma :

[b]row_number() OVER (ORDER BY "Project1".ACC_ID ASC) AS "row_number"[/b]

Could you correct this? Or explain what i am doing wrong, please?

We use Professional edition 5.25.37.0
In trial all worked correctly.

Thanks

Posted: Thu 16 Jul 2009 11:39
by AndreyR
Thank you for the report, the problem is already fixed.
The fix will be included in the next build.

Posted: Thu 16 Jul 2009 16:00
by mars
How soon will be next build?
On next week we should demostrate pilot version, and this feature is critical for us.
Could you upload previous version dotConnect to http://secure.devart.com/ for dowloading, please?

Thanks

Posted: Mon 20 Jul 2009 12:00
by AndreyR
We plan to release the new build in two weeks.