菜鸟問題求教/請高手指點一二
<P>sysbase數據庫一個表中的1條紀錄損壞,無法刪除怎麼辦</P><P>希望得到高人指點</P>
[此贴子已经被作者于2005-9-19 17:31:56编辑过]
你删除时，报什么错呀？ <P>刪除時出現錯誤提示如下; </P>
<P>unable to find in index 'itemmastmp' for table 'itemmastmp'</P>
[此贴子已经被作者于2005-9-19 17:18:57编辑过]
<H4>Unable to find in index '%1' for table '%2'</H4>
<HR noShade SIZE=1>
<TABLE>
<TR>
<TH>Item </TH>
<TH>Value </TH></TR>
<TR>
<TD>SQLCODE </TD>
<TD>–189 </TD></TR>
<TR>
<TD>Constant </TD>
<TD>SQLE_NOT_FOUND_IN_INDEX </TD></TR>
<TR>
<TD>SQLSTATE </TD>
<TD>WI005 </TD></TR>
<TR>
<TD>Sybase error code </TD>
<TD>2727 </TD></TR>
<TR>
<TD>ODBC 2 State </TD>
<TD>ERROR </TD></TR>
<TR>
<TD>ODBC 3 State </TD>
<TD>ERROR </TD></TR>
<TR>
<TD>Parameter 1 </TD>
<TD>Name of invalid index. </TD></TR>
<TR>
<TD>Parameter 2 </TD>
<TD>Name of table containing the invalid index. </TD></TR></TABLE>
<H6>Probable cause </H6>
<P>This is an internal error. If it can be reproduced, it should be reported to iAnywhere Solutions. You should be able to work around the error by dropping and recreating the index.</P>
<P>
<HR noShade SIZE=1>
你要删除的记录不在表的某一个索引中，你可以把该索引删除后重新建立，然后你就可以工作了。</P>
<P>呵呵~~~~~~~~~~</P>
页:
[1]