关于adoquery的appendrecord问题 ( 积分: 200 )

碰到个奇怪的问题，我用ADOQuery添加数据时，如下<br>aloneq.AppendRecord([ip,level,csname,oid,mibtype,value,finterface,now]);<br><br>我在SQL事件探察器中发现有时候会出现<br>exec&nbsp;sp_executesql&nbsp;N'INSERT&nbsp;INTO&nbsp;&quot;EPON&quot;..&quot;realvartb&quot;&nbsp;(&quot;ip&quot;,&quot;address&quot&nbsp;VALUES&nbsp;(@P1,@P2)',&nbsp;N'@P1&nbsp;nvarchar(13),@P2&nbsp;nvarchar(1)',&nbsp;N'192.168.1.156',&nbsp;N'0'<br><br><br>正确的添加语句应该为<br>exec&nbsp;sp_executesql&nbsp;N'INSERT&nbsp;INTO&nbsp;&quot;EPON&quot;..&quot;realvartb&quot;&nbsp;(&quot;ip&quot;,&quot;address&quot;,&quot;csname&quot;,&quot;oid&quot;,&quot;mibtype&quot;,&quot;value&quot;,&quot;interface&quot;,&quot;mondate&quot&nbsp;VALUES&nbsp;(@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8)',&nbsp;N'@P1&nbsp;nvarchar(13),@P2&nbsp;nvarchar(1),@P3&nbsp;nvarchar(13),@P4&nbsp;nvarchar(31),@P5&nbsp;nvarchar(1),@P6&nbsp;nvarchar(17),@P7&nbsp;nvarchar(1),@P8&nbsp;datetime',&nbsp;N'192.168.1.156',&nbsp;N'0',&nbsp;N'oltMACAddress',&nbsp;N'1.3.6.1.4.1.14590.1.1.2.1.1.2.0',&nbsp;N'1',&nbsp;N'00-00-00-00-00-00',&nbsp;N'',&nbsp;'10&nbsp;12&nbsp;2007&nbsp;&nbsp;2:38:05:000PM'<br><br>为什么会有时候出现那种不正确的语句那？

应该是ADO的问题,试试升级MDAC,如果还有问题,那就尝试用其它方式添加记录吧