>Try to recreate the index of the dbc. Looking at your SQL-statement and the index of a dbc, I guess that is it.
>Another possibility: I hope you didn'tfall in the trap of SET DELETED OFF? In that case it's just setting it ON.
>
>HTH,
>
>Lennert
Yes, looks like it was it, the SET DELETED.
If it's not broken, fix it until it is.
My Blog