Tip: Using paging table data with MSSQL #2030
rbartholomay
started this conversation in
Show and tell
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Perhaps someone have the same problem like me:
I try to read a complete external MSSQL-Database Table. The Table is really big so i decide to read this via forPage like this (sample code):
In my case i get an error: "Invalid usage of the option NEXT in the FETCH statement" It seems that MSSQL always need a default sort order! When i add .orderBy('id') all runs fine.
Perhaps some find this useful...
Have a nice day!
René
Beta Was this translation helpful? Give feedback.
All reactions