[RBASE-L] - RE: Sql Server table

[Troy Sosamon]

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