怎样在delphi中用sql语句从foxpro表中选出需要的数据！！sos!!!(100分)

猎

猎户

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-13

• #1

要求：在foxpro表A中B字段为DATE型，怎样用SQL语句”SELECT * FROM A WHERE ？？？“选出B等于2002年3月6日的数据

 

D

dopro

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-13

• #2

with query do
begin
close;
sql.clear;
sql.add('select * from a where b=:b');
params[0].asdate:='2002-03-06';
prepare;
open;
end;

 

W

wql

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-13

• #3

例如a.dbf在c:/abc下

with query do
begin
close;
sql.clear;
sql.add('select * from 'c:/abc/a.dbf' where b=:b');
params[0].asdate:='2002-03-06';
prepare;
open;
end;
注意加引号和路径。

 

猎

猎户

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-13

• #4

params[0].asdate:='2002-03-06';
应为
params[0].asdate:=strtodate('2002-03-06');