提示:实时错误'-2147217887(80040e21)',ODBC驱动程序不支持所需属性
在VB中运行SQL语句是出现该问题:
select ORDER_NO,ORDER_CUSTOMER,ORDER_PO,ORDER_INDENTNO,Order_goodsname,order_item,order_color,order_size,order_count,yy,order_time,order_deldate,order_urgency,order_status,order_ischange,order_iscancel,order_PBno,order_user,order_keytime from (SELECT Order_no,order_customer,Order_po,order_indentno,Order_goodsname,Order_item,Order_color ,order_size,Order_count,isnull(tx.yy,0) as yy,order_time,order_deldate,order_urgency,order_status,order_ischange ,order_iscancel,order_PBno,order_user,order_keytime FROM Order_table tt left join (select storedata_goodsname,storedata_item,storedata_color,storedata_size,sum(storedata_counts) as yy from( select ta.storedata_goodsname,ta.storedata_item,ta.storedata_color,ta.storedata_size,ta.storedata_counts from storedata_table ta union all select sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,SWGOODS_SIZE,-sum(sw.SWGOODS_COUNT)as SWGOODS_tatalcount FROM SWGOODS_TABLE SW WHERE SW.SWGOODS_SIGN='待出货' group by sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,
SW.SWGOODS_SIZE)x group by storedata_goodsname,storedata_item,storedata_color,storedata_size)tx on tx.storedata_goodsname=tt.order_goodsname and tx.storedata_item=tt.order_item and tx.storedata_color=tt.order_color and tx.storedata_size=tt.order_size)At ,size_table st where st.size_name=at.order_size and At.order_status = '已下单' order by at.order_goodsname,at.order_item,at.order_color,st.size_px,at.order_po,at.order_indentno只有其中的条件当我只单选择“已下单”条件时则会报错`,但是我把该语句放在SQL中直接运行不会报错能正常运行
以下语句我加一个筛选条件得出的语句则是正常的`
select ORDER_NO,ORDER_CUSTOMER,ORDER_PO,ORDER_INDENTNO,Order_goodsname,order_item,order_color,order_size,order_count,yy,order_time,order_deldate,order_urgency,order_status,order_ischange,order_iscancel,order_PBno,order_user,order_keytime from (SELECT Order_no,order_customer,Order_po,order_indentno,Order_goodsname,Order_item,Order_color ,order_size,Order_count,isnull(tx.yy,0) as yy,order_time,order_deldate,order_urgency,order_status,order_ischange ,order_iscancel,order_PBno,order_user,order_keytime FROM Order_table tt left join (select storedata_goodsname,storedata_item,storedata_color,storedata_size,sum(storedata_counts) as yy from( select ta.storedata_goodsname,ta.storedata_item,ta.storedata_color,ta.storedata_size,ta.storedata_counts from storedata_table ta union all select sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,SWGOODS_SIZE,-sum(sw.SWGOODS_COUNT)as SWGOODS_tatalcount FROM SWGOODS_TABLE SW WHERE SW.SWGOODS_SIGN='待出货' group by sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,
SW.SWGOODS_SIZE)x group by storedata_goodsname,storedata_item,storedata_color,storedata_size)tx on tx.storedata_goodsname=tt.order_goodsname and tx.storedata_item=tt.order_item and tx.storedata_color=tt.order_color and tx.storedata_size=tt.order_size)At ,size_table st where st.size_name=at.order_size and At.order_status = '已下单' and convert(datetime,AT.order_time) between '2010-10-19' and '2010-10-19' order by at.order_goodsname,at.order_item,at.order_color,st.size_px,at.order_po,at.order_indentno
在VB中运行SQL语句是出现该问题:
select ORDER_NO,ORDER_CUSTOMER,ORDER_PO,ORDER_INDENTNO,Order_goodsname,order_item,order_color,order_size,order_count,yy,order_time,order_deldate,order_urgency,order_status,order_ischange,order_iscancel,order_PBno,order_user,order_keytime from (SELECT Order_no,order_customer,Order_po,order_indentno,Order_goodsname,Order_item,Order_color ,order_size,Order_count,isnull(tx.yy,0) as yy,order_time,order_deldate,order_urgency,order_status,order_ischange ,order_iscancel,order_PBno,order_user,order_keytime FROM Order_table tt left join (select storedata_goodsname,storedata_item,storedata_color,storedata_size,sum(storedata_counts) as yy from( select ta.storedata_goodsname,ta.storedata_item,ta.storedata_color,ta.storedata_size,ta.storedata_counts from storedata_table ta union all select sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,SWGOODS_SIZE,-sum(sw.SWGOODS_COUNT)as SWGOODS_tatalcount FROM SWGOODS_TABLE SW WHERE SW.SWGOODS_SIGN='待出货' group by sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,
SW.SWGOODS_SIZE)x group by storedata_goodsname,storedata_item,storedata_color,storedata_size)tx on tx.storedata_goodsname=tt.order_goodsname and tx.storedata_item=tt.order_item and tx.storedata_color=tt.order_color and tx.storedata_size=tt.order_size)At ,size_table st where st.size_name=at.order_size and At.order_status = '已下单' order by at.order_goodsname,at.order_item,at.order_color,st.size_px,at.order_po,at.order_indentno只有其中的条件当我只单选择“已下单”条件时则会报错`,但是我把该语句放在SQL中直接运行不会报错能正常运行
以下语句我加一个筛选条件得出的语句则是正常的`
select ORDER_NO,ORDER_CUSTOMER,ORDER_PO,ORDER_INDENTNO,Order_goodsname,order_item,order_color,order_size,order_count,yy,order_time,order_deldate,order_urgency,order_status,order_ischange,order_iscancel,order_PBno,order_user,order_keytime from (SELECT Order_no,order_customer,Order_po,order_indentno,Order_goodsname,Order_item,Order_color ,order_size,Order_count,isnull(tx.yy,0) as yy,order_time,order_deldate,order_urgency,order_status,order_ischange ,order_iscancel,order_PBno,order_user,order_keytime FROM Order_table tt left join (select storedata_goodsname,storedata_item,storedata_color,storedata_size,sum(storedata_counts) as yy from( select ta.storedata_goodsname,ta.storedata_item,ta.storedata_color,ta.storedata_size,ta.storedata_counts from storedata_table ta union all select sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,SWGOODS_SIZE,-sum(sw.SWGOODS_COUNT)as SWGOODS_tatalcount FROM SWGOODS_TABLE SW WHERE SW.SWGOODS_SIGN='待出货' group by sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,
SW.SWGOODS_SIZE)x group by storedata_goodsname,storedata_item,storedata_color,storedata_size)tx on tx.storedata_goodsname=tt.order_goodsname and tx.storedata_item=tt.order_item and tx.storedata_color=tt.order_color and tx.storedata_size=tt.order_size)At ,size_table st where st.size_name=at.order_size and At.order_status = '已下单' and convert(datetime,AT.order_time) between '2010-10-19' and '2010-10-19' order by at.order_goodsname,at.order_item,at.order_color,st.size_px,at.order_po,at.order_indentno
解决方案 »
- mscomm采集不到数据(在线等急急急急!)
- VB中的控件
- VB+ORACLE数据库提示实时错误如何处理-进程内存不足
- 讨论一下。。vb什么时候该用api?
- 一个ACCESS数据库,我如何用VB知道他有多少个表,并且这些表的表名是什么?
- 请问VB里面哪个函数能把一个日期或时间类型的数据中的年,月,日,时,分,秒分别提取出?
- 循环增加数据
- 未发现可创建的公共类部件
- 请问怎样在form1中引入一个子窗体form2,并且指定form2在form1中的位置和大小?
- <1元版权>推荐一下,哪个远端控制软件做的最好?冰河?还是?............
- 用ADO控件连接MYSQL数据库的具体过程是怎样的?在网上查了不少时间,现在还没连接上
- 我在VB中如何打开visual basic form file啊?
不是权限的问题``这个可以确认,而且后者我条件多一点就没问题