当查询有效时，ASP.NET DataAdapter查询无效

Question

我在6个月前的ASP.net web应用程序中开始使用DataSet。这是一个漂亮的工具，允许我快速开发MVC应用程序，而无需在数据库连接/查询中完成所有肮脏的工作。

但今天我遇到了一些奇怪的问题。它开始与此查询：

select a.MR_PART_CODE as PART_CODE,

 b.PART_DESC as PART_DESC, 
     b.PM_MAD_CAT_CODE as CATEGORY, 
     c.MPC_MIN_QTY as CAT_SS, 
     a.MR_MAX_LEAD_TIME as LEAD_TIME, 
     a.MR_MAD as MAD, 
     ROUND((a.MR_MAD * a.MR_MAX_LEAD_TIME)) as CAL_SS, 
     greatest(ROUND((a.MR_MAD * a.MR_MAX_LEAD_TIME)),c.MPC_MIN_QTY) as SS, 
     d.SOH as SOH, 
     d.SOO as SOO, 
     (select sum(back_order) from STK_REQUEST where part_code=b.part_code) as BO, 
     (d.SOH+a.MR_SOO) as AVAIL, 
     ((d.SOH + a.MR_SOO)-greatest(ROUND((a.MR_MAD * a.MR_MAX_LEAD_TIME)),c.MPC_MIN_QTY)) as ROQ, 
     (d.SOH - greatest(ROUND((a.MR_MAD * a.MR_MAX_LEAD_TIME)),c.MPC_MIN_QTY)) as VAR, 
     a.MR_REMARKS as REMARKS   
    from ROQ a, PART_MASTER b, MAD_PARTS_CATEGORY c, PART_STATS d 
    where a.MR_PART_CODE = b.PART_CODE 
    and d.PART_CODE = b.PART_CODE 
    and b.PM_MAD_CAT_CODE = c.MPC_CAT_CODE 
    and b.RETIRE_FLAG = 'N' 
    and a.mr_year = (select max(mr_year) from roq) 
    and a.mr_month = (select max(mr_month) from roq where mr_year= (select max(mr_year) from roq)) 
    and a.mr_period = (select max(mr_period) from roq where mr_month=(select max(mr_month) from roq where mr_year= (select max(mr_year) from roq)) and mr_year= (select max(mr_year) from roq)) 
    and  greatest(ROUND((a.MR_MAD * a.MR_MAX_LEAD_TIME)),c.MPC_MIN_QTY) > d.SOH` 

查询蟾蜍跑细了甲骨文，但显然它，当我试图安装在DataAdapter对象一个新的查询失败。它说这样的行：“函数参数列表中的错误：SELECT not recognized”： (select sum(back_order) from STK_REQUEST where part_code=b.part_code) as BO

我做错了什么？

仅供参考，数据库是Oracle。

Answer 1

这似乎是一些尝试解析SQL的ASP类的例外。如果消息来自Oracle，将会有一个ORA-xxxxx错误号。

你不应该把这样的SQL放在ASP中。相反，创建一个视图，也许它没问题。