RE: [Emerald] How do I delete a ServiceType?

• Next message: Tommy Cheng: "Re: [Emerald] Another SQL question"
• Previous message: Tommy Cheng: "Re: [Emerald] Another SQL question"
• In reply to: Ronnie Franklin: "RE: [Emerald] Another SQL question"
• Next in thread: Tommy Cheng: "Re: [Emerald] How do I delete a ServiceType?"
• Reply: Tommy Cheng: "Re: [Emerald] How do I delete a ServiceType?"

From: "Dale E. Reed Jr." <daler@iea-software.com>
Subject: RE: [Emerald] How do I delete a ServiceType?
Date: Fri, 9 May 2003 14:38:11 -0700
Message-ID: <EFEHJGKHFGPNMBOJINBFKEHJCAAA.daler@iea-software.com>

> I changed all of the SubAccounts that were using this particular
> ServiceType
> to an other ServiceType:
> [UPDATE SubAccounts SET AccountTypeID=21 WHERE
> (SubAccounts.AccountTypeID=14)]
>
> But I still cannot delete it.

AccountTypeID is used in other places as well. The InvoiceItems RadATConfigs, and so forth reference it as well. If you set the sortorder to either 255 (pre 4.5.4) or negative (4.5.4 or higher), it will no be displayed.

Dale

• Next message: Tommy Cheng: "Re: [Emerald] Another SQL question"
• Previous message: Tommy Cheng: "Re: [Emerald] Another SQL question"
• In reply to: Ronnie Franklin: "RE: [Emerald] Another SQL question"
• Next in thread: Tommy Cheng: "Re: [Emerald] How do I delete a ServiceType?"
• Reply: Tommy Cheng: "Re: [Emerald] How do I delete a ServiceType?"