delphi中的SQL语句问题？　　 (50分)

剑

剑无心

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #1

请教：我的sql语句要这样实现
select top 3 * from table1 where aaa='abc.pic' order by a desc

要动态实现：
sqlstr:='select top 3 * from table1 where aaa=' 以后怎么写？
——————————
剑无心，见无形[]

 

S

shangshang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #2

delphi中

sqlstr:='select top 3 * from table1 where aaa='+#39+'abc.pic' '+#39+' order by a desc ';

 

D

dhl2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #3

select top 3 * from table1 where aaa=:namestr order by a desc

parameters.parabyname('namestr').asstring:='abc.pic'

 

剑

剑无心

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #4

可惜程序不认为这是正确的，
另外：aaa的数据类型为nvarchar

 

四

四库全书

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #5

sqlstr:='select top 3 * from table1 where aaa=' + '''abc.pic + ''' +' order by a desc '

 

C

chshanghai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #6

sqlstr:='select top 3 * from table1 where aaa=:aaa'
query.sql.clear;
query.sql.add(sqlstr)
query.params.parambyname('aaa').value:='abc.pic'
query.prepare
query.open

 

F

fly_delphi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #7

picStr:='abc.pic';
SqlStr:='Select top3 * from table1 where aaa='''+picStr+''' order by a desc';

 

剑

剑无心

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #8

出现的提示为：Invalid variant type conversion.

 

G

GanQuan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #9

>>sqlstr:='select top 3 * from table1 where aaa=' 以后怎么写？
sqlstr := 'select top 3 * from table1 where aaa=' + '''' + 'abc.pic' + '''' + ' order by a desc';

 

E

Eva

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #10

sqlstr:='select top 3 * from table1 where aaa=' + '''' + abc.pic + '''' + 'order by a desc ';

 

王

王森章

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #11

fly_delphi 的解释是正确的。

 

M

micro73

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #12

var
str1:string;
SqlStr:=format('Select top 3 * from table1 where (aaa=%s) order by a desc',[str1]);

 

剑

剑无心

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #13

可是错误的提示总是相同的

 

弟

弟子

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #14

来晚了。这么多好方法，我再说就是“同上”了。[]

 

Z

zuidaeji

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #15

关键是你的后台数据库是什么？不同的数据库平台语法不同。

 

剑

剑无心

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #16

后台数据库是：sqlserver2000

 

D

dopro

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #17

with query1 do
begin
close;
sql.clear;
sql.add(''select top 3 * from table1 where aaa=:aaa order by a desc ');
params[0].asstring:=外部传入的值；
prepare;
open;
end;

 

剑

剑无心

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #18

可是我没有使用Tquery组件

 

S

shangshang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #19

受不了了，你把你的调用代码还是贴出来吧。

 

T

the_lover

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-10

• #20

用一个COMBOBOX把字符加进去然后
SQL：=COMBOBOX1.ITEMS;