Imail can't create a new view when you add a domain (like it does with a table), can it?? And, it wouldn't know how to add a new user. You can't add a new row to a view while still maintaining the view's filters.
For example, you would have an ImailMasterUsers table with a DomainName column tacked on at the end, and several Views (domain1_com, domain2_com, etc_com) that displayed all users for a particular domain (view definition would be "SELECT * FROM ImailMasterUsers WHERE DomainName = 'domain2.com'"). If Imail tried to add a row into the domain1_com view, it would add it into the ImailMasterUsers table, but it would insert <NULL> into the DomainName field. Am I missing something? -- Alex Nikdel [EMAIL PROTECTED] Kingham Software, Inc ePolk.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanford Whiteman Sent: Tuesday, July 06, 2004 1:43 PM To: Alex Nikdel Subject: Re: [IMail Forum] odbcuser dll file > Has anyone written a copy of odbcuser.dll that incorporates all > Imail users into one table (with a DomainName field to filter > users)? We don't like having them all in separate tables within the > db. It gets a bit unwieldy when you have several hundred domains > (and about to add another 150), to have a separate table for each > domain. You don't need a rewrite--just use views. --Sandy ------------------------------------ Sanford Whiteman, Chief Technologist Broadleaf Systems, a division of Cypress Integrated Systems, Inc. e-mail: [EMAIL PROTECTED] SpamAssassin plugs into Declude! http://www.mailmage.com/products/software/freeutils/SPAMC32/download/release / Defuse Dictionary Attacks: Turn Exchange Addresses into IMail Aliases! http://www.mailmage.com/products/software/freeutils/exchange2aliases/downloa d/release/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
