MailCreInBoxTables

sql

FUNCTION MailCreInBoxTables(IN profile CHAR(63)) RETURNS INT;

Parameters

profile name of the mailing profile defined in 602SQL

Since version

8.1

Description

This function creates a couple of working tables, which are necessary for working with received mail. If the profile parameter equals NULL, the _INBOXMSGS and _INBOXFILES table will be created in the _SYSEXT system application (and this application is created if necessary). If profile is a name of an existing profile, the table for storing information about letter will be given name according to the InBoxMessages profile parameter, the table for storing information about attachments according to the InBoxFiles profile parameter, both in the application according to the InBoxAppl profile parameter.

These table will be created on the first attempt to open the mailbox if this function isn't called.

If the tables already exist, the function will have no effect. If the tables were created in the old format (version older than 7.0d), they'll be modified to the current format.

The main significance of this function is to possibility of spreading the application to a computer with standard installation (no tables for receiving mail). A more complex application using the mail API require the presence of these tables even when the stored procedures.

The names and table location may be found with the MailGetInBoxInfo function.

Function value

This function returns 0 if successful, the error number otherwise.

See