ListManager.CreateFromSegment
Use this method to create a list from a Predictor resource segment.
Definition
Function CreateFromSegment(listName As String,listDesc As String,lFlags As Long,userFlags As Long,modelName As String,segmentName As String,predHostName As String,DWConnStr As String,fpMinProbability As Double,bAsync As Boolean,Optional pvarOpID As Variant) As Variant
Parameters
listName
A String that contains provides the name for the list.
listDesc
A String that contains the list description.
lFlags
A Long that specifies the bitmask flags that control the type of list created.
userFlags
A Long that contains application specific user flags. Not used by the ListManager object.
modelName
A String that contains the name of the Predictor segment model to use.
segmentName
A String that contains the name of the segment to import.
predHostName
A String that contains the name of the Predictor host server.
DWConnStr
A String that contains the Data Warehouse connection string.
fpMinProbability
A Double that contains the minimum probability associated with a given segment member for that member to be included in the list.
bAsync
A Boolean that specifies whether the creation operation is performed synchronously or asynchronously. A value of True indicates asynchronous processing.
pvarOpID
An optional Variant used to return an Operation ID.
Return Values
If this method completes successfully, it returns a Variant used to return the new list ID.
Error Values
This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to either standard or custom COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors.
The following table shows the custom COM errors that this method can return.
Constant | Value | Description |
E_LM_CONNECTIONFAILED | &H8C400001 | Failed to establish database connection. |
E_LM_CREATE_OBJECT | &H8C400017 | Unable to create the object. |
E_LM_INVALID_FLAGS | &H8C400005 | Invalid flags value. |
E_LM_LIST_ALREADY_EXISTS | &H8C400007 | The specified list has already been created. |
E_LM_MAILABLE_LIST_NO_EMAILS | &H8C40000D | The list is designated as a Mailable list but does not contain an rcp_email column. |
E_LM_OPER_CANCELED | &H8C40000B | The operation was canceled. |
E_LM_SQLERROR | &H8C400003 | Error while executing SQL/ADO operation. |
E_LM_USER_LIST_NO_GUIDS | &H8C40000E | The list is designated as a User list but does not contain an rcp_guid column. |
OLE_E_BLANK | &H80040007 | The ListManager object has not been properly initialized. |
Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.
Remarks
This method calls into the PredictorServiceSiteAdmin object, passing it the modelName, segmentName, and fpMinProbability parameters along with a connection string to the database used by the ListManager object, and the table name that it should create.
For a list of possible values for the lflags parameter, see the GetListFlags method.
For more information about memory ownership issues related to COM property and method parameters, see Managing COM Parameter Memory.
Example
' vListID is a Variant
vListID = oListManager.CreateFromSegment("TequillaBuyers", _
"Thirty year old tequilla buyers ", 20, 0, "Tequilla", "Thirty", _
"TequillaServer", "Provider=SQLOLEDB;Data Source=servername;" & _
"Initial Catalog=Retail_dw;User ID=user;Password=********;", False)