MethodText = "if (lower(list_nthitem(MailboxPath, 1, '" + globals.MailboxDivider + "')) = 'inbox' or lower(list_nthitem(MailboxPath, 1, '" + globals.MailboxDivider + "')) = 'sent' or lower(list_nthitem(MailboxPath, 1, '" + globals.MailboxDivider + "')) = 'sent messages', "
MethodText = MethodText + "list_nthitem(MailboxPath, 1, '" + globals.MailboxDivider + "'), list_nthitem(MailboxPath, list_itemcount(MailboxPath, '" + globals.MailboxDivider + "'), '" + globals.MailboxDivider + "'))"
if MailboxTable.CreateVarCharField("MailboxPathName", 1000, EVFlag.fNullable + EVFlag.fIndexed, MethodText) = Nil then
Globals.theErrorLog.LogItem "Error creating MailboxPath Name"
end if
I need to change the method for existing databases. How do I do that?
