请问用如下语句创建视图为什么老出错?query1.close;
query1.sql.clear;
query1.sql.add('create view TheView as select number,sum(quantity) from db where (type=''J'') and (Thedate between :DateBegin and :DateEnd) order by number group by bumber');
query1.parambyname('DateBegin').value := strtodate(formatdatetime('yyyy-mm-dd',datetimepicker1.date));
query1.parambyname('Dateend').value := strtodate(formatdatetime('yyyy-mm-dd',datetimepicker2.date));
query1.execsql;number,quantity,type,Thedate都为数据库里的字段,分别为编号、数量、单据类型、日期
query1.sql.clear;
query1.sql.add('create view TheView as select number,sum(quantity) from db where (type=''J'') and (Thedate between :DateBegin and :DateEnd) order by number group by bumber');
query1.parambyname('DateBegin').value := strtodate(formatdatetime('yyyy-mm-dd',datetimepicker1.date));
query1.parambyname('Dateend').value := strtodate(formatdatetime('yyyy-mm-dd',datetimepicker2.date));
query1.execsql;number,quantity,type,Thedate都为数据库里的字段,分别为编号、数量、单据类型、日期
解决方案 »
- 关于delphi与mscomm组件
- 高分求:Delphi-ADOQuery查询数据库时,真实反映查询进度条?
- 请教使用cxGrid的CardView时,如何去掉字段标题上用于筛选的小三角?
- 图像转换(bmp——>gif;pg——>gif)
- 一个菜鸟的简单问题,还请大家解答
- ★如何防止弹出网页窗口
- 急!!! delphi7中作报表的控件在哪? 各位高手帮忙, 在线等待!!!
- ●●●●我发现一个好工具软件,大家来看看,跟贴者有分,不够再加。
- 怎么能给一个让一个label显示 ''%'' (用代码)
- 再问:200分!!! 关于 OleContainer 的问题:我用OleContainer内嵌了一个Excel Worksheet到程序中,可是我不知道如何在程序中控制它....
- 用indy的idpop3控件如何存储邮件附件到本地硬盘?
- 窗体问题
ORACLE建视图时不支持用参数
query1.close;
query1.sql.clear;
query1.sql.text := 'create view TheView as select number,sum(quantity) from db where (type=''J'') and (Thedate between ''' + formatdatetime('yyyy-mm-dd',datetimepicker1.date) + ''' and ''' + formatdatetime('yyyy-mm-dd',datetimepicker2.date) + ''') order by number group by bumber';
query1.execsql;
老早就不用foxpro了