在线等(10分)

令

令狐冲001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #1

delphi 7 调用access数据库.mdb
str:='select * from a where 时间<=#'+'2006-1-1 1:01:01 '+'#';
with adoquery1 do
.......
open;
出现错误,怎么回事? 将2006-1-1 1:01:01 换成2006-1-1则可以,换句话说支持date而不支持datetime

 

令

令狐冲001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #2

系统提示:不正常地定义参数对象.提供了不一致或不完整的信息

 

J

Johnny_du

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #3

这样：
with ADOQuery do
begin
SQL.Clear;
SQL.Add('SELECT * FROM A WHERE 时间<=:aDate');
ParamByName('aDate').AsDateTime := StrToDateTime(''2006-1-1 1:01:01');
Open;
end;

 

Z

zhsmile

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #4

一般我用
t1:=strToDateTime('2006-1-1 1:01:01');
s:=format('select * from a where 时间<%6.4f',[t1]);

 

A

allenj0928

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #5

把时间格式转换一下

 

令

令狐冲001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #6

ParamByName undeclared

 

令

令狐冲001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #7

z再问
var
t1,t2:Tdatetime;
......
str:='select * from a where 时间>=#'+datetimetostr(t1)+'#';
str:=str+' and 时间<=#'+datetimetostr(t2)+'#';
又该如何?

 

S

sefeng1982

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #8

没用过access,不过印象中应该也可以 datetime 的啊

 

令

令狐冲001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #9

sql server 就没问题

 

J

Johnny_du

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-01

• #10

with ADOQuery do
begin
SQL.Clear;
SQL.Add('SELECT * FROM A WHERE 时间<=:aDate');
Parameters.ParamByName('aDate').AsDateTime := StrToDateTime(''2006-1-1 1:01:01'); //呵呵，刚才丢了一个参数Parameters，不好意思
Open;
end;