delphi中SQL的使用(50分)

F

fsxusuh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-21

• #1

各位高手:
请问在delphi的SQL动态查询中,当查询参数为整型时,如何设置?
即类似如下:
m_Num为Integer;
m_SQL:='SELECT * FROM m_TableName WHERE 序号='+''''+m_Num+'''';

2000.09.21
fsxusuh@mail.fsptt.ln.cn

 

J

jqw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-21

• #2

m_SQL:='SELECT * FROM m_TableName WHERE 序号='+Inttostr(m_Num);

 

A

arm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-21

• #3

m_SQL:='SELECT * FROM m_TableName WHERE 序号=m_Num'
QUERY1.CLOSE;
QUERY1.SQL.CLEAR;
QUERY1.SQL.ADD(M_SQL);
QUERY1.PARAMS[0].ASINTEGER:=M_NUM;
QUERY1.OPEN;

 

Y

yunshang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-21

• #4

用QUERY控件,在其SQL属性中加入:

SELECT * FROM m_TableName WHERE 序号='+''''+:m_Num+''''

在程序中:
QUERY1.OPEN;
QUERY1.PARAMBYNAME('m_Num').ASINTEGER:=你的值;
QUERY1.EXECSQL;

 

W

wang4762

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-21

• #5

m_SQL:='SELECT * FROM m_TableName WHERE 序号='+inttostr(m_Num)+''
你可试一下，应该能过。

 

王

王剑鑫

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-21

• #6

m_sql:='select * from m_tablename where 序号='+intostr(m_num)

 

A

aidy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-09-21

• #7

最好用参数法，这样更准确。

mySQL:='SELECT * FROM m_TableName WHERE 序号= m_Num'
QUERY1.CLOSE;
QUERY1.SQL.CLEAR;
QUERY1.SQL.ADD(mySQL);
QUERY1.PARAMS[0].ASINTEGER:=MYNUM;
QUERY1.OPEN;

 

W

wjiachun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-10-25

• #8

多人接受答案了。

 

J

jqw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-10-26

• #9

伙计,你有点不公平,是我先回答的.
真不好意思