Tech Support > Microsoft Windows > Windows CRM > Need to delete read only records
Need to delete read only records
Posted by Brian on June 22nd, 2006


Hello, I'm trying to get rid of some bogus test quotes that were
entered in CRM. These quotes were entered by test users and the quotes
were flagged as "won". If you try to delete these you get the error
that they are read-only records. These bogus quotes are showing up in
report data and I need them to disappear.

Does anyone know what flags or status code I need to change in the sql
tables to allow a system admin to "re-open" those records and delete
them.

Thanks in advance,

Brian

Posted by Peter Lynch on June 22nd, 2006


UPDATE QuoteBase
SET statecode = 0
WHERE <insert-your-filter-criteria>


"Brian" <graphicunity@gmail.com> wrote in message
news:1150995985.756023.109020@y41g2000cwy.googlegr oups.com...


Posted by Brian on June 22nd, 2006


Thanks Peter! I'll give it a try.

Brian
Peter Lynch wrote:


Similar Posts