一个数据库查询问题。(100分)

L

lanse

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #1

各位帮帮忙！本人不大懂SQL查询语句。今天做程序碰到了一个问题：
Query1.Close;
Query1.SQL.Clear;
query1.SQL.Add('select * from P_RuKu.db where ComeDate>'+''''+DateTimePicker1.Date+'''');
query1.Prepare;
query1.ExecSQL;
query1.Open;
if query1.RecNo=0 then
Application.MessageBox('在此时间段没有找到记录！', '信息......',MB_OK+MB_ICONASTERISK);
编译通过了，但实际运行有问题。
觉得query1.SQL.Add('select * from P_RuKu.db where ComeDate>'+''''+DateTimePicker1.Date+'''');这句
语法上就有问题。请帮我把正确的写下好吗？

 

H

HIGOAL

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #2

query1.SQL.Add('select * from P_RuKu.db where ComeDate>'+DateTimePicker1.Date+')';

 

M

mlzhou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #3

Query1.Close;
Query1.SQL.Clear;
query1.SQL.Add('select * from P_RuKu.db where ComeDate>'+''''+DateTimePicker1.Date+'''');
query1.Prepare; //去掉
query1.ExecSQL; //去掉
query1.Open;

 

完

完颜康

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #4

query1.SQL.Add('select * from P_RuKu.db where ComeDate>'+''''+DateTimeToStr(DateTimePicker1.Date)+'''');

 

G

Give Me Magic

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #5

query1.SQL.Add('select * from P_RuKu.db where ComeDate>'+
DateToStr(DateTimePicker1.Date));

 

C

chur

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #6

query1.SQL.Add('select * from P_RuKu.db where ComeDate>"'+DateTimePicker1.Date+"')';

 

H

HIGOAL

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #7

Query1.SQL.Clear;
query1.SQL.Add('select * from P_RuKu.db where ComeDate>:mydate');
query1.parambyname('mydate').asdate:=datetimepicker1.date;
Query1.SQL.open;

 

C

chenzheng770101

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #8

有参数吧
Query1.Close;
Query1.SQL.Clear;
query1.SQL.Add('select * from P_RuKu.db where ComeDate>：datepick');
query1.params[0].asdatetime:=DateTimePicker1.Date ;
query1.Prepare;
query1.open;
注：datepick是参数

 

G

Give Me Magic

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #9

Query1.Close;
Query1.SQL.Clear;
query1.SQL.Add('select * from P_RuKu.db where ComeDate>'+DateToStr(DateTimePicker1.Date));
query1.Open;
if query1.RecordCount=0 then
Application.MessageBox('在此时间段没有找到记录！', '信息......',MB_OK+MB_ICONASTERISK);
//并没有变换DateTimePicker1，用参数多此一举。

 

L

lovedp

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #10

if Query1.Active Then Query1.Close;
Query1.SQL.Clear;
query1.SQL.Add('select * from P_RuKu.db where ComeDate>'''+DateTimePicker1.Date+'''');
query1.Open;
//变量应用'''+变量名+'''来表示

 

D

dlnew

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #11

execsql 当QUERY的操作不返回结果
OPEN 当QUERY的操作只返回结果

 

L

lanse

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-04

• #12

谢谢各位的帮忙！