📄 14486.html

📁 VB技巧问答10000例 VB技巧问答10000例

💻 HTML

字号:

<html>
  <head>
    <title>请问 &quot; 无数值提供给一或多个必要参数&quot; ???</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>请问 &quot; 无数值提供给一或多个必要参数&quot; ???</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by 皮皮 on June 22, 1999 at 09:53:41:<p>
In Reply to: <a href="14467.html">Re: 单一资料库处理条件不足 Sorry,再请教</a> posted by 安宝 on June 21, 1999 at 18:15:22:<p>
<br>: : My问题：<br>: : Table Detail(栏位Lotid,recipeid,trackoutti)<br>: : Table Aoi(栏位Lotid,Trackoutii)<br>: : Aoi Table 某些Trackoutii栏位是空值<p>: : 欲将detail Table 之Trackoutii栏位<br>: : 塞到Aoi TableTrackoutii栏位(NULL方作此动作)<br>: : (detail[Lotid+recipeid]对到 aoi[Lotid]<br>: :  recipeid=AO001.01 )<p>: My Solution as follow :<p>: update Aoi set Trackoutti = {Detail.trackoutti}<br>: where LOTID={Detail.LOTID} AND (RECIPEID <br>: LIKE 'AO001.01') AND (aoi.TRACKOUTTI IS NULL)<p><br>The result is "无数值提供给一或多个必要参数"<br>ps:I Use VB6 之 dataenvironment之SQL RUN<br>请问是哪出了问题<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 14486-->
<!--top: 14490--><li><a href="14490.html">只能建议 ...</a> <b>安宝</b> <i>11:15:14 6/22/99</i>
(<!--responses: 14490-->1)
<ul><!--insert: 14490-->
<!--top: 14496--><li><a href="14496.html">谢谢安宝,vb6之updat指令好像不支援其他Table,我已用他法解决.(无内文)</a> <b>皮皮</b> <i>11:54:21 6/22/99</i>
(<!--responses: 14496-->0)
<ul><!--insert: 14496-->
</ul><!--end: 14496-->
</ul><!--end: 14490-->
</ul><!--end: 14486-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -