[RBASE-L] - RE: Sql Server table

[Roberto Zanotti]

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