> Imail can't create a new view when you add a domain (like it does > with a table), can it??
That it cannot, but one hopes you do not have so many domain adds/changes/deletes that that step cannot be separately scripted. In fact, the whole domain-creation step can be scripted in one fell swoop. > 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. Sure you can! > 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'"). You can use a LIKE filter on the e-mail address field in your view definition, so there's no NOT NULL column that is not populated. --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/download/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/
