为什么有错误：Query1:Field 'Mybh' is of an unknown type.(0分)

D

delphi_hzj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-15

• #1

var Mybh:string;
begin
Mybh:=edit1.text;
Query1.SQL.text:='select sum(je) as Myje from cd.dbf where Bh=:mybh';
query1.open;
edit11.text:=query1.fieldByname('Myje').asstring;
query1.close;
end;

以上代码在试运行时。为什么有错误：Query1:Field 'Mybh' is of an unknown type.

 

I

itprogram

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-15

• #2

Query1.SQL.text:='select sum(je) as Myje from cd.dbf where Bh=mybh';

 

G

GanQuan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-15

• #3

参数赋值了吗？

 

X

xuejian

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-15

• #4

Query1.close;
Query1.sql.clear;
Query1.sql.add(''select sum(je) as Myje from cd.dbf where Bh='''+mybh+'''');
Query1.open;
你试试！

 

K

Kang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-15

• #5

去掉var mybh:string;的变量声明
begin
Query1.SQL.text:='select sum(je) as Myje from cd.dbf where Bh=:mybh';
Query1.ParamByName('mybh').AsString:=Trim(Edit1.Text);
query1.open;

 

G

gongwith

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-15

• #6

Query1.SQL.text:='select sum(je) as Myje from cd.dbf where Bh=''''mybh''''';

 

D

delphi_hzj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-17

• #7

前些日子这里我上不来了，没给大家回贴，不好意思。
谢谢。问题解决了。