旺财兄,表已经存在,不过就是不能drop table tablename??
解决方案 »
- 我用delphi新建工程编译出来360江民就误报!
- 一个很简单的问题,关于类的,请达人帮手,刚接手delphi,
- 已知FastReport报表中,有一对象名字为"Memo1",如何在程序中直接给它的内容赋值?
- 请求帮助!!!!!
- ISAPI下调用HTTP接口的问题
- 有没有vcl的高手?一个关于combobox的简单的问题!
- ADO控件问题?求助!
- 请问,哪位知道哪里有Farpoint Spread,或者Formula One可以下。
- 多谢各位捧场,为了感谢各位支持,再次送分!并且如果有什么好的程序之类愿意以分交换!
- 会者不难!
- delphi中怎么判断一个字符串是不是数字?
- 能不能在一个TChart控件中同时显示两个Y坐标?????
on DispatchList
for insert
as
select CASE datalength(rtrim(ltrim(str(max(cvouchid)+1))))
when 1 then 'R0000000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 2 then 'R000000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 3 then 'R00000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 4 then 'R0000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 5 then 'R000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 6 then 'R00000'+rtrim(ltrim(str(max(cvouchid+1))))
when 7 then 'R0000'+rtrim(ltrim(str(max(cvouchid+1))))
when 8 then 'R000'+rtrim(ltrim(str(max(cvouchid+1))))
when 9 then 'R00'+rtrim(ltrim(str(max(cvouchid+1))))
End as cLink,
CASE datalength(rtrim(ltrim(str(max(cvouchid)+1))))
when 1 then '000000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 2 then '00000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 3 then '0000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 4 then '000000'+rtrim(ltrim(str(max(cvouchid+1))))
when 5 then '00000'+rtrim(ltrim(str(max(cvouchid+1))))
when 6 then '0000'+rtrim(ltrim(str(max(cvouchid+1))))
when 7 then '000'+rtrim(ltrim(str(max(cvouchid+1))))
when 8 then '00'+rtrim(ltrim(str(max(cvouchid+1))))
when 9 then '0'+rtrim(ltrim(str(max(cvouchid+1))))
End as cvouchid,max(cVouchType) as cVouchtype,max(cexch_name) as cexch_name,max(cFlag) as cFlag
into kk2 from Ap_vouch
Select b.*,a.dDate as DVouchdate,a.Ccuscode as CdwCode,a.cDepCode as cDeptcode,a.cPersoncode as cPerson,a.isum-a.cdefine7 as
iRAmount into kk3 from SA_DispatchListEX a,kk2 b where a.kflag<>'A'
insert into ap_vouch(cLink,cVouchid,cVouchtype,cExch_name,cFlag,dVouchdate,cdwcode,cdeptcode,cperson,iramount) select * from kk3
drop table kk2 //如何删除表(临时表,如果不删除的话下一次就会出错,你有其他方法吗??
drop table kk3 //如何删除表
go