急需自定义SQL语句的代码,有的关照一下~可以参照SQLSERVER里面的视图,可以说是一个图形化的SQL语句生成器~有代码的给小弟一份~也可以不一定是图形化的,只要是自定义SQL语句的就可以~小弟先谢了~
解决方案 »
- 在向DAT文件写一个字符串数组的时候多了一个黑颜色的小方块
- HTML怎样调用在OCX usercontrol里面的过程和函数呢?
- 关于2个EXCLE之间,按模糊字段统计数量
- 关于MSChart的问题
- 我前段时间用 vb写了一个程序,重新装了一个系统,现在再运行时,运行到那个date函数提示编译错误或库未运行,请教是什么原因?
- 怪事,TreeView无法加载数据?
- 日期比较!
- 在窗口系统菜单中添加了自定义菜单项后如何响应单击操作?
- vb 找不到工程或库
- 有个问题,请教各位,为何读出数据库中的图片,会出现错误??
- 诚求:共同合作编写小型POS收款系统 小型人事工资系统等软件
- 这个SQL语句怎么写阿???? 80分求购
先把要改变的东西都设为变量,然后用&连起来就组成sql语句了
CREATE OR REPLACE VIEW KRV_KRUP010B AS
SELECT
substr(KRR_URIAGE.simhi,1,6) AS NENGET,
KRR_URIAGE.TOKCD AS TOKCD,
KRR_URIAGE.GENCD AS GENCD,
KRM_TOKUI.TOKNM AS TOKNM,
KRM_GENBA.GENNM AS GENNM,
sum(nvl(krr_uriage.su_risgak,0)) AS su_risgak,
sum(nvl(krr_uriage.su_tasgak,0)) AS su_tasgak,
sum(nvl(krr_uriage.su_hsygak,0)) AS su_hsygak,
sum(nvl(krr_uriage.su_bikgak,0)) AS su_bikgak,
sum(nvl(krr_uriage.su_tnbgak,0)) AS su_tnbgak,
sum(nvl(krr_uriage.su_urkgak,0)) AS su_urkgak,
sum(nvl(krr_uriage.su_utnugak,0)) AS su_utnugak,
sum(nvl(krr_uriage.su_kjiugak,0)) AS su_kjiugak,
sum(nvl(krr_uriage.su_zeigak,0)) AS su_zeigak
FROM KRM_GENBA,KRM_TOKUI,KRR_URIAGE
WHERE
krm_tokui.tokcd(+) = krr_uriage.tokcd
and krm_genba.tokcd(+) = krr_uriage.tokcd
and krm_genba.gencd(+) = krr_uriage.gencd
group by
substr(KRR_URIAGE.simhi,1,6) ,
KRR_URIAGE.TOKCD ,
KRR_URIAGE.GENCD ,
KRM_TOKUI.TOKNM ,
KRM_GENBA.GENNM
order by
KRR_URIAGE.TOKCD ,
KRR_URIAGE.GENCD
dbo.spt_fallback_usg.xdttm_ins AS Expr2,
dbo.spt_fallback_usg.xfallback_vstart AS Expr3, dbo.spt_monitor.lastrun AS Expr4,
dbo.spt_monitor.io_busy AS Expr5, dbo.spt_monitor.idle AS Expr6,
dbo.spt_monitor.total_read AS Expr7, dbo.spt_monitor.pack_sent AS Expr8,
dbo.spt_monitor.connections AS Expr9,
dbo.spt_fallback_usg.xdttm_last_ins_upd AS Expr10,
dbo.spt_fallback_usg.sizepg AS Expr11,
dbo.spt_fallback_usg.segmap AS Expr12
FROM dbo.spt_monitor LEFT OUTER JOIN
dbo.spt_fallback_usg ON
dbo.spt_monitor.lastrun = dbo.spt_fallback_usg.xserver_name RIGHT OUTER JOIN
dbo.spt_provider_types ON
dbo.spt_fallback_usg.xserver_name = dbo.spt_provider_ty
要是只实现简单功能的话是很容易的,若是要包括大部分SQL语句即比较难.
如:
要显示那个字段,做个List框供用户选择,
查询条件就做个两个List框和一个文本框,第一个是查询条件的字段名,第二个是查询条件的关系(=、Not、Like等),文本框就是查询条件的值了。(字段1='aa')
编写像SQL Server那样的视图比较复杂,要图形化,要能够自动检查错误。。