[RBASE-L] - RE: Sql Server table

[Roberto Zanotti]

Dear Buddy Probably I've found the solution. To be able to do a select order by a field it is necessary to have an index over this field A question: your field Des_Nbr is indexed?   Thank You Roberto Zanotti BMB Informatica ITALY     ----- Original Message ----- From: Walker, Buddy To: RBASE-L Mailing List Sent: Thursday, June 26, 2003 4:11 PM Subject: [RBASE-L] - RE: Sql Server table Roberto   I sconnect to an SQL Server and both work fine.       SELECT Des_Nbr FROM Des_Med WHE Des_Nbr <= 1229 ORDER BY Des_Nbr       SELECT Des_Nbr FROM Des_Med ORDER BY Des_Nbr WHE Des_Nbr <= 1229       I'm using     R:Base 6.5++  Build 1.866xRT03   SQL Server ODBC version 2000.81.9001.00 Dtd 2/19/2002   Buddy     -----Original Message----- From: Roberto Zanotti [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 9:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sql Server table Dear Troy   I 've tried  SELECT IOSONO FROM VALORI ORDER BY IOSONO with no other clause but i've got the same error (VALORI is my table name and IOSONO is my column name)     Roberto Zanotti BMb Informatica Italy   ---- Original Message ----- From: Troy Sosamon To: RBASE-L Mailing List Sent: Thursday, June 26, 2003 3:37 PM Subject: [RBASE-L] - RE: Sql Server table Make sure you have your select clause formed properly.  R:base will let you flip flop the where and the order by, but sql will not. I think  the order by needs to come before the where clause.   Troy   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Roberto Zanotti Sent: Thursday, June 26, 2003 7:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Sql Server table I have this problem   I've attached an SQL Server 2000 table to my r:base database with the sattach command. Now i'm able to do a select command and to get the records.  The problem is that if i make a select with the 'order by' clause then the Microsoft ODBC Sql Server Driver send the error message 'Cursor Type Modified' Someone knows how to resolve this problem?   Thanks   Roberto Zanotti BMB Informatica Italy