Message-ID: <011a01c1eb0a$445906d0$b7010a0a@aurumtechnology.com> From: "Jason Newland" <newlandj@areatech.com> Subject: Re: [Emerald] SQL Query Date: Tue, 23 Apr 2002 16:03:00 -0500
UPDATE SubAccountData SET SubAccountData.Data = 10000000 WHERE
SubAccountData.DataTypeID = 3
----- Original Message -----
From: "Jim Sheldon" <jsheldon@texascom.com>
To: "'Emerald Support List'" <emerald@iea-software.com>
Sent: Tuesday, April 23, 2002 3:56 PM
Subject: [Emerald] SQL Query
> I am not familiar with SQL queries and wondered if anyone would be able
> to help me with a simple query. I need the following update:
>
> Set Data = 10000000 when DataTypeID = 3 in the SubAccountData table of
> my Emerald 4 database.
>
> This is to do a mass update of the max mailbox size for Imail for all my
> users.
>
> Jim Sheldon
> Texas Communications
> 979-775-6239 x340
>
.