我用的三层结构
在前端调用数据时老是出现
raised exception class edbclient with message 'invalid parameter'
下面是代码
with cntRefer do
begin
close;
temp:=' select a.BillNo,a.sequence as BillSeqNum,a.itemno,b.ItemName,b.ModeSpec,a.MeasureUnit,b.costprice as LocalPrice, '+
' b.BarCode,b.OldItemNo,'''' as TradeName,isnull(quantity,0) as AllQty,0 as TranOutQty,a.reserved4 as VendCustCode,a.reserved5 as VendCustName '+
' from pur_transorderdetail a,pub_itemlist b ,pur_transordermaster c '+
' where a.itemno=b.itemno and c.billno=a.billno '
commandtext:=temp;
open;事实上里面根本就没有用到参数
请哪位大侠指教一下我
在前端调用数据时老是出现
raised exception class edbclient with message 'invalid parameter'
下面是代码
with cntRefer do
begin
close;
temp:=' select a.BillNo,a.sequence as BillSeqNum,a.itemno,b.ItemName,b.ModeSpec,a.MeasureUnit,b.costprice as LocalPrice, '+
' b.BarCode,b.OldItemNo,'''' as TradeName,isnull(quantity,0) as AllQty,0 as TranOutQty,a.reserved4 as VendCustCode,a.reserved5 as VendCustName '+
' from pur_transorderdetail a,pub_itemlist b ,pur_transordermaster c '+
' where a.itemno=b.itemno and c.billno=a.billno '
commandtext:=temp;
open;事实上里面根本就没有用到参数
请哪位大侠指教一下我
解决方案 »
- delhpi 子form怎么调用主form 的MainMenu1的子项属性呢?
- delphi 调用相关问题~!!!!~~~~
- 使用odac时将net打为true,连接数据库时报错:service unvavilable!如何这是什么原因啊?
- 怎么用写程序控制TOMCAT启动和退出????
- 出现一个很奇怪的问题,高手请进!
- TdxBarPopupMenu为什么在关闭主窗口后,还遗留在桌面上???
- mdi里面combobox和scollbox控件的问题
- fastReport中如何控制每页只打印10条数据,但数据库中的记录是不定的!
- 诚征调试存储过程终极解决方案!
- 菜鸟想速成,求教个问题
- 怎么样从TStream取出存在里面的图像,显示到Image控件中呢?
- 关于'Image'控件
temp:=' select a.BillNo,a.sequence as BillSeqNum,a.itemno,b.ItemName,b.ModeSpec,a.MeasureUnit,b.costprice as LocalPrice, '+
' b.BarCode,b.OldItemNo,'''' as TradeName,isnull(quantity,0) as AllQty,0 as TranOutQty,a.reserved4 as VendCustCode,a.reserved5 as VendCustName '+
' from pur_transorderdetail a,pub_itemlist b ,pur_transordermaster c '+
' where a.itemno=b.itemno and c.billno=a.billno '
commandtext:=temp;
直接把SQL语句赋给commandtext就可以了,没有必要用temp;
改了还是有误的
begin
Params.Clear; //可能你在别的地方加用到了参数