1,216
社区成员
发帖
与我相关
我的任务
分享(急,在线等待)VB6中升级Access数据库视图？？？？
怎么在VB6中升级Access数据库视图，我的视图中包含有 union 语句。
谢谢！我的SQL语句如下
SELECT 'hpos_StockIncomeBill_Dtl' as tableName,M.billId,M.supplier as orgId,M.store,M.billDate,M.billNo,M.handler,M.billType, D.dtlId,D.barcode,productId,qty,price,pieceQty,axesWeight,0.0 as outqty,0.0 as outprice,0.0 as outpieceQty,0.0 as outaxesWeight,D.comment
FROM hpos_StockIncomeBill_Dtl AS D INNER JOIN hpos_StockIncomeBill_Master AS M ON M.billId=D.billId
UNION ALL SELECT 'hpos_StockOutBill_Dtl' as tableName,M.billId,M.takeunit as orgId,M.store,M.billDate,M.billNo,M.handler,M.billType, D.dtlId,D.barcode,productId,0.0,0.0,0.0 ,0.0,qty ,price,pieceQty,axesWeight ,D.comment
FROM hpos_StockOutBill_Dtl AS D INNER JOIN hpos_StockOutBill_Master AS M ON M.billId=D.billId;
谢谢！我的SQL语句如下
SELECT 'hpos_StockIncomeBill_Dtl' as tableName,M.billId,M.supplier as orgId,M.store,M.billDate,M.billNo,M.handler,M.billType, D.dtlId,D.barcode,productId,qty,price,pieceQty,axesWeight,0.0 as outqty,0.0 as outprice,0.0 as outpieceQty,0.0 as outaxesWeight,D.comment
FROM hpos_StockIncomeBill_Dtl AS D INNER JOIN hpos_StockIncomeBill_Master AS M ON M.billId=D.billId
UNION ALL SELECT 'hpos_StockOutBill_Dtl' as tableName,M.billId,M.takeunit as orgId,M.store,M.billDate,M.billNo,M.handler,M.billType, D.dtlId,D.barcode,productId,0.0,0.0,0.0 ,0.0,qty ,price,pieceQty,axesWeight ,D.comment
FROM hpos_StockOutBill_Dtl AS D INNER JOIN hpos_StockOutBill_Master AS M ON M.billId=D.billId;
...全文
请发表友善的回复…
发表回复
yuvotesyg518 2006-07-21
- 打赏
- 举报
汗，不知道你的问题是什么？？
penghongjie 2006-07-21
- 打赏
- 举报
怎么每人答复啊？？？？
难道这个问题就搞不定
难道这个问题就搞不定
penghongjie 2006-07-21
- 打赏
- 举报
to:yuvotesyg518
我的意思就是通过VB6程序执行SQL脚本更新数据库视图；先删除已经存在的视图然后再创建。
我的意思就是通过VB6程序执行SQL脚本更新数据库视图；先删除已经存在的视图然后再创建。
