能否在query查询的数值字段中再乘以一个数值变量代码如下(50分)

W

wecap

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #1

以下代码运行时错误，提示，参数不足
w:=strtoint(form7.Label16.Caption);
adotable5.Post;
query1.Close;
query1.SQL.Clear;
query1.SQL.add('select 货物编号,定额数量,定额数量*w as 需求数量 from 生产需求');
query1.open;

 

A

Alex_Y

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #2

应该可以,加个括弧.

 

Z

zhanzehua

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #3

应该这样
'select 货物编号,定额数量,定额数量*'
+ form7.Label16.Caption+ 'as 需求数量 from 生产需求'

 

X

xjc_first

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #4

同意樓上.

 

Z

zhlqq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #5

数据库中要有 “定额数量*w” 的值对应的字段才行。
'select 货物编号,定额数量,'+String(定额数量*w)+' as 需求数量 from 生产需求'

 

L

laibin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #6

query1.SQL.add('select 货物编号,定额数量,定额数量*:vari as 需求数量 from 生产需求');
parambyname('vari').asfloat:=w;

 

L

laibin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #7

query1.SQL.add('select 货物编号,定额数量,定额数量*:vari as 需求数量 from 生产需求');
parambyname('vari').asinteger:=w;

 

Z

zhengyoukang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-08

• #8

//w:=strtoint(form7.Label16.Caption);
adotable5.Post;
query1.Close;
query1.SQL.Clear;
query1.SQL.add('select 货物编号,定额数量,定额数量*:w as 需求数量 from 生产需求');
parambyname('w').asinteger:=strtoint(form7.Label16.Caption);
query1.open;

 

W

wecap

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-09

• #9

接受答案了.