Hi!
Yes. Just reindex command. If do not help, drop index than create it again.
>If the table 's index is corruped Due to the PC hangs.
>
>so, If i use
>=SEEK(ALLTRIM(pKey),"invoiceheader","number")
>
>It may return the wrong result ???
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.