在MIDAS三层中,使用CommandText很奇怪的SELECT语句使用order by 后内容.系统错误解析的问题 (100分)

在MIDAS三层中,使用CommandText传入以下内容可正常执行
set transaction isolation level read uncommitted
select * from mybase..users
set transaction isolation level read committed
使用以下语句
set transaction isolation level read uncommitted
select * from mybase..users order by vc_user
set transaction isolation level read committed
系统报set字段没有找到,好象系统把
set transaction isolation level read committed
中的set也当字段解析了.
如果处理本情况呢?

set transaction isolation level read uncommitted
select * from mybase..users order by vc_user
set transaction isolation level read committed
使用以下语句
set transaction isolation level read uncommitted
select * from mybase..users order by vc_user
set transaction isolation level read committed

两句有什么不同？[]

没看懂

试试
set transaction isolation level read uncommitted;
select * from mybase..users order by vc_user;
set transaction isolation level read committed;

可直接在查询分析器中试试

语句已经在查询分析中测试过,是没有问题的.
另:服务器端程序用DELPHI6编译后测试就没有本问题,但DELPHI5为什么有这问题呢?