解决方案 »
- VB数组元素过多,运行出现占用太多资源,使得程序无法运行。。如何解决
- [全部分都送上!]要一份关于MSCOMM控件的使用资料~~!~~!!!
- 如何用VB提取数据库中的内容
- 我有一个问题从到CSDN来一直都没想通过,比如我刚才问的问题,怎么让托盘里的小程序的弹出菜单消失,就有人告诉我用SetForegroundWindows
- 这个查询怎么实现啊。--在线等。高手帮帮忙。急!
- 百倍提高运行速度,极速sql记录倒入excel表格,19个子段5万条记录只需30秒,欢迎大家来讨论!
- 数据库问题!
- 请问vb使用AVISaveOptions时如何才能不弹出视频压缩对话框,谢谢!
- 求助?怎样让frame中的所有控件同比例缩小?
- 怎样读取text数据源?怎样识别text中存在的诸如#之类的分隔符?(即在程序那里写入分隔符的信息?)
- 关于Base64编码的难题,请高手进来帮忙(VB6调用javascript函数示例)
- vb 编写 上位机,在主控响应后上位机界面txtReceive显示字节:第一个字节丢失,请教怎么处理?
conn.ConnectionString = connstr
connstr = "Provider=OraOLEDB.Oracle;Data Source=hdqt_db;User Id=dbusrhq;Password=futurehq"
conn.Open connstr
rs.CursorLocation = adUseClient
strsql = "select ta.gbid ""商品代码"",ta.gbbarcode ""商品条码"", "
strsql = strsql & "ta.gbcname ""商品名称"",ta.gbspec""规格"",ta.gbunit ""计量单位"","
strsql = strsql & "ta.gbsupid ""主营供应商"",tb.gmfmfid ""柜组"" "
strsql = strsql & "from goodsbase ta,goodsmframe tb,"
strsql = strsql & "(select gmfgdid,gmfmfid from goodsmframe "
strsql = strsql & "where gmfstatus = 'Y' and gmfet = '1003' and gmfmfid = '10030111' "
strsql = strsql & "minus select distinct jglgdid, jglmfid from jxcgoodslist where jgltran <> 'E' "
strsql = strsql & "and (jxcgoodslist.jglfsdate >=to_date ('2014-03-09', 'yyyy-mm-dd') "
strsql = strsql & "and jxcgoodslist.jglfsdate < to_date ('2014-06-09', 'yyyy-mm-dd')+1)"
strsql = strsql & "and jglmfid = '10030111' minus select distinct jglgdid, jglmfid from jxcgoodslist "
strsql = strsql & "where jgltran = '1' and 'jxcgoodslist.jgldate' = 'jxcgoodslist.jgldate' "
strsql = strsql & "and (jxcgoodslist.jglfsdate >= to_date('2014-05-09', 'yyyy-mm-dd')"
strsql = strsql & "and jxcgoodslist.jglfsdate < to_date('2014-06-09', 'yyyy-mm-dd') + 1)"
strsql = strsql & "and jglmfid = '10030111') tc "
strsql = strsql & "where ta.gbid = tb.gmfgdid and tc.gmfgdid = tb.gmfgdid "
strsql = strsql & "and ta.gbid = tc.gmfgdid and tb.gmfmfid = '10030111' "
strsql = strsql & "order by ta.gbid"
rs.Open strsql, conn, adOpenKeyset, adLockPessimistic
Set DataGrid1.DataSource = rs
MsgBox "查询完成!", , "成功提示"
End Sub如果还有别的更好方法欢迎交流学习