var
str:string;begin
str:='select sj01"人员编号",isnull(sum(sj05),0)"加款总额",count(*)"加款笔数" into #A from s_sj where sj12 like ''%加款'' group by sj01 select sj01"人员编号",isnull(sum(sj05),0)"减款总额",count(*)"减款笔数" into #B from s_sj where sj12 like ''%减款'' group by sj01 select sk01"人员编号",isnull(sum(sk05)/10,0)"消费总额",count(*)"消费笔数" into #C from s_sk group by sk01 select sd01"人员编号",sd14"卡中余额" into #D from s_sd select #D.人员编号,#A.加款总额,isnull(#B.减款总额,0) as 减款总额,isnull(#C.消费总额,0) as 消费总额,#D.卡中余额 into #T from #D inner join #A on #D.人员编号 = #A.人员编号 left join #B on #D.人员编号 = #B.人员编号 left join #C on #D.人员编号=#C.人员编号 select * from #T where 加款总额<>减款总额+消费总额+卡中余额';
"string"最多只能含有255个字符,可我的语句中已经超过了255,我该怎么办啊??
有没有比“string”功能更大一点的啊,在线等,大家帮帮忙啊
str:string;begin
str:='select sj01"人员编号",isnull(sum(sj05),0)"加款总额",count(*)"加款笔数" into #A from s_sj where sj12 like ''%加款'' group by sj01 select sj01"人员编号",isnull(sum(sj05),0)"减款总额",count(*)"减款笔数" into #B from s_sj where sj12 like ''%减款'' group by sj01 select sk01"人员编号",isnull(sum(sk05)/10,0)"消费总额",count(*)"消费笔数" into #C from s_sk group by sk01 select sd01"人员编号",sd14"卡中余额" into #D from s_sd select #D.人员编号,#A.加款总额,isnull(#B.减款总额,0) as 减款总额,isnull(#C.消费总额,0) as 消费总额,#D.卡中余额 into #T from #D inner join #A on #D.人员编号 = #A.人员编号 left join #B on #D.人员编号 = #B.人员编号 left join #C on #D.人员编号=#C.人员编号 select * from #T where 加款总额<>减款总额+消费总额+卡中余额';
"string"最多只能含有255个字符,可我的语句中已经超过了255,我该怎么办啊??
有没有比“string”功能更大一点的啊,在线等,大家帮帮忙啊
解决方案 »
- 如何在XP和2000下隐藏进程??
- 我做了一个只能读一行文本的程序,想把它改成读多行的程序,如何做???
- 求关于如何根据ClientDataSet.Delta提交数据的函数
- DELPHI循环读取TMemo里的内容,并添加到MDB数据库中。
- 郁闷...郁闷...极度郁闷.......散.................散光光......
- 散分!!!请问哪有有关Delphi里SQL的基础语法与使用语句的电子书下载?谢谢!
- 如何在delphi程序运行时得到当前应用的版本信息?
- 哪里有Crystal Report 下载?
- 我用Query写insert into 语句到oracle数据库。。怎么提交?这样写可以吗?
- 我刚学DELPHI一个星期。现急需用delphi做一个网吧计费管理系统,哪位仁兄能雪中送炭?<[email protected]><qq:24748621>
- 窗口的打开与关闭问题
- 关于摄像头编程的一个问题,困扰了很久…………
---------------
请问,这是谁告诉您的?有经过测试吗?procedure TForm1.Button1Click(Sender: TObject);
var
Str: String;
begin
Str := 'a'; //1个'a'
Str := Str + Str + Str + Str + Str + Str + Str + Str + Str + Str; //10个'a'
Str := Str + Str + Str + Str + Str + Str + Str + Str + Str + Str; //100个'a'
Str := Str + Str + Str + Str + Str + Str + Str + Str + Str + Str; //1000个'a'
//Str := Str + Str + Str + Str + Str + Str + Str + Str + Str + Str; //10000个'a'
ShowMessage(Str);
end;
str:='select sj01"人员编号",isnull(sum(sj05),0)"加款总额",count(*)"加款笔数" '+
+'into #A from s_sj where sj12 like ''%加款'' group by sj01 select '+
+'sj01"人员编号",isnull(sum(sj05),0)"减款总额",count(*)"减款笔数" into #B from '+
+'s_sj where sj12 like ''%减款'' group by sj01 select '+
+'sk01"人员编号",isnull(sum(sk05)/10,0)"消费总额",count(*)"消费笔数" into #C from '+
+'s_sk group by sk01 select sd01"人员编号",sd14"卡中余额" into #D from s_sd select '+
+'#D.人员编号,#A.加款总额,isnull(#B.减款总额,0) as 减款总额,isnull(#C.消费总额,0) '+
+'as 消费总额,#D.卡中余额 into #T from #D inner join #A on #D.人员编号 = '+
+'#A.人员编号 left join #B on #D.人员编号 = #B.人员编号 left join #C on '+
+'#D.人员编号=#C.人员编号 select * from #T where '+
+'加款总额<>减款总额+消费总额+卡中余额';
比如说str := 'abcdefghijklmn';
可以改为str := 'abcdefgh';
str := str + 'ijklmn';
默认情况下的string就是WideString
------
看错了,还以为是说AnsiString呢,默认的String是AnsiString
可惜要报错哦
str:='select sj01"人员编号",isnull(sum(sj05),0)"加款总额", '+
'count(*)"加款笔数" into #A from s_sj '+
'where sj12 like ''%加款'' group by sj01 '+
'select sj01"人员编号",isnull(sum(sj05),0)"减款总额", '+
'count(*)"减款笔数" into #B from s_sj '+
'where sj12 like ''%减款'' group by sj01 '+
'select sk01"人员编号",isnull(sum(sk05)/10,0)"消费总额", '+
'count(*)"消费笔数" into #C from s_sk '+
'group by sk01 select sd01"人员编号",sd14"卡中余额" '+
'into #D from s_sd select #D.人员编号,#A.加款总额, '+
'isnull(#B.减款总额,0) as 减款总额, '+
'isnull(#C.消费总额,0) as 消费总额,#D.卡中余额 '+
'into #T from #D inner join #A on #D.人员编号 = #A.人员编号 '+
'left join #B on #D.人员编号 = #B.人员编号 '+
'left join #C on #D.人员编号=#C.人员编号 '+
'select * from #T where 加款总额<>减款总额+消费总额+卡中余额';haha!
报错提示如下:
Project Project1.exe raised exception class ENoResultSet with message 'Error cresting cursor handle'.Process stopped.Use Step or Run to continue.
这是怎么了啊?我要怎么做啊?、请指点指点啊
语句在数据库中运行没有问题,