莫
莫征文
Unregistered / Unconfirmed
GUEST, unregistred user!
操作系统:WINDOWS2000 SERVER
SQL SERVER 7.0
DELPHI6.0
用TDATABASE联接数据库,用TQUERY
写的视图创建语句如下:
query1.close;
query1.sql.clear;
query1.sql.add('create view myview
as select * from mytable
where starttime between _Begin and _End');
query1.parambyname('P_Begin').asdatetime:=datetimepicker1.date;
query1.parambyname('P_End').asdatetime:=datetimepicker2.date;
query1.excesql;
运行后报错(大概意思):sql ...error at keyword 'view'
到底是什么问题?
哪位大虾帮帮忙?
30分
SQL SERVER 7.0
DELPHI6.0
用TDATABASE联接数据库,用TQUERY
写的视图创建语句如下:
query1.close;
query1.sql.clear;
query1.sql.add('create view myview
as select * from mytable
where starttime between _Begin and _End');
query1.parambyname('P_Begin').asdatetime:=datetimepicker1.date;
query1.parambyname('P_End').asdatetime:=datetimepicker2.date;
query1.excesql;
运行后报错(大概意思):sql ...error at keyword 'view'
到底是什么问题?
哪位大虾帮帮忙?
30分