一条sql语句问题???(50分)

Y

yy-xx-pp

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-06

• #1

在query1的sql中用select * from B where x between :x(注明：‘x’存放字符型的日期),
然后我在form中的两个edit的text中存放开始日期和结束日期（如1970和1990）,
在程序中：query1.parambyname('x').asstring:=edit1.text+' and '+edit2.text;
query1.open;
结果老是提示‘unexpected end of commond’错误，我查了query1.sql.text的内容，
觉得都没错误，问题在哪里？

 

C

cocia

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-06

• #2

select * from B where x between :x and :y
//-----
query1.parambyname('x').asstring:=edit1.text;
query1.parambyname('y').asstring:=edit2.text;
//---
//ok
Give me scores!!!

 

D

DJ.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-06

• #3

query1.parambyname('x').asstring:='convert(datetime,'''+edit1.text+''') and convert(datetime,'''+edit2.text+''')';

 

F

Fred2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-06

• #4

你用什么数据库
1。access or paradox
format('select * from B where x between ''%s'' and ''%s''',
[formatdatetime('mm/dd/yyyy',StartDate)
,formatdatetime('mm/dd/yyyy',FinishDate)]));

2.oracle
format('select * from B where x between to_date(''yyyy-mm-dd'',''%s'')
and to_date(''yyyy-mm-dd'',''%s'')',
[StartDate,FinishDate]));

 

L

lipingcool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-06

• #5

可以用cocia的方法,也可用下面的代码:
select * from B where x between '''+edit1.text+''' and '''+edit2.text+'''

 

Y

yy-xx-pp

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-06

• #6

多人接受答案，分数已经给！

 

W

wjiachun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-12-18

• #7

多人接受答案了。