高分，哪位DX能提供，SQL2000 中Bit类型的ADOQuery查询语句(150分)

D

dingcs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-20

• #1

我在做一人事系统，人员表中HF为Bit类型，记录“婚否”。<br>下面语句出错：<br>with ADOQUERY1 do<br>begin<br>&nbsp; close;<br>&nbsp; SQL.clear;<br>&nbsp; SQL.text:='select * from RenYuan where HF = true';<br>&nbsp; open;<br>end;<br>提示：列名“true”无效；<br>希望高手给我正解。<br>急，我在线等。

 

D

dingcs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-20

• #2

大哥们，我急呢，帮帮忙。

 

刘

刘卫民

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-20

• #3

bit类型用0、1表示<br>将SQL语句改为<br>select * from RenYuan where HF = 1

 

X

XF.Lian

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-20

• #4

'select * from RenYuan where HF = 1'<br>'select * from RenYuan where HF = 0'<br><br>1 -true &nbsp;0-false

 

B

bigwell

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-24

• #5

sql.text:='elect * from RenYuan where HF =qvalue';<br>parameters.paramvalues['@qvalue']:=True;<br>or<br>parameters.paramvalues['@qvalue']:=False;

 

Y

ycluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-24

• #6

同意楼上的