ClientDataSet1的commandtext的语法如何写？(50分)

D

dana

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-08-15

• #1

将query的sql语句改为commandtext如何改?
var xj0:boolean;
SQL.CLEAR;
SQL.ADD('SELECT * FROM YHZH');
SQL.ADD('where (XJ=_XJ)');
PARAMBYNAME('P_XJ').ASBOOLEAN:=XJ0;
open;

 

Z

zore

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-08-16

• #2

这样就行了 。
var xj0:boolean;
close;
commandtext :='SELECT * FROM YHZH where (XJ=_XJ)'
PARAMBYNAME('P_XJ').ASBOOLEAN:=XJ0;
open;

 

J

jackl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-08-16

• #3

同意zore的看法

 

X

xinyt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-09-06

• #4

跟写SQL语句完全一样

 

D

dana

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-10-26

• #5

多人接受答案了。