sql中convert没定义？ (10分)

X

xiaocai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #1

query1.close;
query1.sql.clear;
query1.sql.add('select * from mytable');
query1.sql.add('where convert(int,aram)<=convert(int,a01)');
query1.parambyname('param').asstring:='10';
query1.prepare;
query1.open;
库为ACCESS，运行，出错
General SQL error
[Microsoft][ODBC Microsoft ACCESS驱动程序]表达式中convert函数未定义

 

S

sherman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #2

query1.close;
query1.sql.clear;
query1.sql.add('select * from mytable');
query1.sql.add('where a01>=a');
query1.parambyname('pa').asstring:='10';
query1.prepare;
query1.open;

 

X

xiaocai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #3

忘了说了，我的库中储存的字段是STRING类型的，但是比较的时候要弄成INTEGER才行
必须用CONVERT

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #4

Access不支持Convert吧？[]

 

X

xiaocai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #5

啊，那怎么办啊，请看我刚才问的问题
http://www.delphibbs.com/delphibbs/dispq.asp?lid=1153759

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-10

• #6

也是转换，不过不能是convert了。尝试使用
如下：
select int(col1),int(col2) from table1

 

X

xiaocai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-14

• #7

接受答案了.