Morten Brun
|
Posted: 05/09/2002, 9:47 AM |
|
When I try to sort a column in the Grid I get the following Error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
An ORDER BY clause is invalid in views, derived tables, and subqueries
unless TOP is also specified.
/CitiLinks/Admin/Classes.asp, line 1412
Any sugestion on how to remedy this problem please...
Morten
|
|
|
Barry G. Sumpter
|
Posted: 05/09/2002, 2:04 PM |
|
Hi Morten,
We've answered this recently.
Use your search and search messages text for TOP.
baz
"Morten Brun" <morb@novonordisk.com> wrote in message
news:cs9lduk0ruk8b3r530gmmld17aanv27hcf@4ax.com...
> When I try to sort a column in the Grid I get the following Error:
>
>
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> An ORDER BY clause is invalid in views, derived tables, and subqueries
> unless TOP is also specified.
> /CitiLinks/Admin/Classes.asp, line 1412
>
>
>
>
> Any sugestion on how to remedy this problem please...
>
> Morten
|
|
|
Alexey Alexapolsky
|
Posted: 05/10/2002, 1:01 AM |
|
This is fixed and will be available soon.
--
Alex
CodeCharge Developer
"Morten Brun" <morb@novonordisk.com> wrote in message
news:cs9lduk0ruk8b3r530gmmld17aanv27hcf@4ax.com...
> When I try to sort a column in the Grid I get the following Error:
>
>
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> An ORDER BY clause is invalid in views, derived tables, and subqueries
> unless TOP is also specified.
> /CitiLinks/Admin/Classes.asp, line 1412
>
>
>
>
> Any sugestion on how to remedy this problem please...
>
> Morten
|
|
|
|
|