怎样把sql语句执行的结果放到变量里? ( 积分: 20 )

D

dafuwengqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-05-18

• #1

with sql do
begin
cli closecl
add('select flag1 into :f from kch ');
add('where kch=:kc');
end;
parameters.ParamByName('kc').Value :=kch;
parameters.ParamByName('f').Value :=flag;
tishi

 

D

dafuwengqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-05-18

• #2

with sql do
begin
cli closecl
add('select flag1 into :f from kch ');
add('where kch=:kc');
end;
parameters.ParamByName('kc').Value :=kch;
parameters.ParamByName('f').Value :=flag;
tishi

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-05-18

• #3

s:='select flag1 into %s from kch where kch=:kc";
s:= format(s,[tablename]);
sql.clear;
sql.add(s);
parameters.ParamByName('kc').Value :=kch;

 

D

dafuwengqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-05-18

• #4

我是想在kch表中把kch为kc的flag值放到一个delphi的变量f里面.
f:boolean;

 

A

atoi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-05-18

• #5

你这样操作行不通的，还是用FieldByName('flag1').AsBoolean吧