是什么错误的？急急急急急急急急急(0分)

D

dabing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-12

• #1

xd:tdatetime;
yd:tdatetime;


q_sql:='select a.ip ,b.intime from b,a where a.ip=sb and b.intime>=xd and b.intime<=yd ';

query2.parambyname('xd').asdatetime:= datetime1;
query2.parambyname('yd').asdatetime:=datetime2;

老是有错误：query2arameter 'xd'not found'
是什么错误的？急急急急急急急急急

 

X

xiao_min

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-12

• #2

q_sql:='select a.ip ,b.intime from b,a where a.ip=sb and b.intime>=:xd and b.intime<=:yd ';

 

B

BlueWin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-12

• #3

xd,yd前加':'

 

D

dabing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-12

• #4

我改过来了，但是又来了个错误？是不是oracle的表的字段建立有问题？
project project2.exe raised exception class edbengineerror with message 'invalid field name'
ora-00904:无效列名',

 

B

BlueWin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-12

• #5

sb不存在,请赋值

 

D

dabing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-12

• #6

sb 已经在前面附过值了
~~

 

B

BlueWin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-12

• #7

q_sql:='select a.ip ,b.intime from b,a where a.ip='''+sb +''' and b.intime>=:xd and b.intime<=:yd ';
这么基础都不懂?