# Re: 单一资料库处理条件不足 Sorry,再请教

Posted by 安宝 on June 21, 1999 at 18:15:22:

In Reply to: Re: 单一资料库处理条件不足 Sorry,再请教 posted by 皮皮 on June 21, 1999 at 17:49:00:

: : 问题1. 选入五个资料栏转入一个资料栏 (f1 & f2 & ...) ?
: : 问题2. 新增或是修改 ? (Insert/Update...)
: : 问题3. 单一资料库 (aoi) 转入条件为何 (LOTID)?

: Sorry,因交代不清楚以致您无法回答

: 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 Trackoutii = {Detail.trackoutii}
where LOTID={Detail.LOTID} AND (RECIPEID
LIKE 'AO001.01') AND (TRACKOUTTI IS NULL)

Of cause , Some fields you need to do some modify. But the basic rule is that you just treat this section as single database - No joint process in here.

Good luck to you.

Follow Ups:

- 请问 " 无数值提供给一或多个必要参数" ??? 皮皮 09:53:41 6/22/99 (2)
  - 只能建议 ... 安宝 11:15:14 6/22/99 (1)
    - 谢谢安宝,vb6之updat指令好像不支援其他Table,我已用他法解决.(无内文) 皮皮 11:54:21 6/22/99 (0)