该怎么办???(200分)

L

liufang1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #1

我在TQUEY的SQL书写:
insert into T_new (dh,n1,n2,n3,n4,n5)
select T1.dh,T1.n1,T1.n2,T1.n3,T1.n4-T2.n4,T1.n5
from T1,T2
where T1.dh=T2.dh and (T1.n4-T2.n4)<>0
其中T1,T2,T_new是三个结构完全相同的.DBF表都含有(dh,n1,n2,n3,n4,n5)
五个字段.执行上述查询时提示:表达式类型不匹配,该怎么办???

 

O

okmy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #2

delphi的例子:INSERT INTO PROJECTS
SELECT * FROM NEW_PROJECTS
WHERE NEW_PROJECTS.START_DATE > |-JUN-1994|

 

L

liufang1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #3

我的写法和你的没有差别呀!我只是让:
T_new.n4的值等于T1.n4-T2.n4
这没什么不对吧!!??

 

L

liufang1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #4

报错提示为:"type mismatch in expression"
敬请高手们不吝指教.

 

H

hntangwei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #5

n4是什么类？能+-吗？

 

C

churchill

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #6

语句好像没问题.

 

C

cytown

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #7

insert into T_new (dh,n1,n2,n3,n4,n5) values (
select T1.dh,T1.n1,T1.n2,T1.n3,T1.n4-T2.n4,T1.n5
from T1,T2
where T1.dh=T2.dh and (T1.n4-T2.n4)<>0)

 

Z

zhangc

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #8

n4的类型不同，字符型的。

 

C

cytown

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-09-23

• #9

肯定应该是数字型的.

 

C

cAkk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-03-15

• #10

多人接受答案了。