# 请问 " 无数值提供给一或多个必要参数" ???

Posted by 皮皮 on June 22, 1999 at 09:53:41:

In Reply to: Re: 单一资料库处理条件不足 Sorry,再请教 posted by 安宝 on June 21, 1999 at 18:15:22:

: : My问题：
: : Table Detail(栏位Lotid,recipeid,trackoutti)
: : Table Aoi(栏位Lotid,Trackoutii)
: : Aoi Table 某些Trackoutii栏位是空值

: : 欲将detail Table 之Trackoutii栏位
: : 塞到Aoi TableTrackoutii栏位(NULL方作此动作)
: : (detail[Lotid+recipeid]对到 aoi[Lotid]
: : recipeid=AO001.01 )

: My Solution as follow :

: update Aoi set Trackoutti = {Detail.trackoutti}
: where LOTID={Detail.LOTID} AND (RECIPEID
: LIKE 'AO001.01') AND (aoi.TRACKOUTTI IS NULL)

The result is "无数值提供给一或多个必要参数"
ps:I Use VB6 之 dataenvironment之SQL RUN
请问是哪出了问题

Follow Ups:

- 只能建议 ... 安宝 11:15:14 6/22/99 (1)
  - 谢谢安宝,vb6之updat指令好像不支援其他Table,我已用他法解决.(无内文) 皮皮 11:54:21 6/22/99 (0)