BuildLoadpointWhere Method

Builds a where clause to use in querying for database records based on their loadpoint.

Syntax

Visual Basic
C#

'Declaration
 
Public Function BuildLoadpointWhere( _
   ByVal tableName As String _
) As String

'Usage
 
Dim instance As CallbackLoadpointList
Dim tableName As String
Dim value As String
 
value = instance.BuildLoadpointWhere(tableName)

public string BuildLoadpointWhere( 
   string tableName
)

Parameters

tableName: The database table name to preface the column names or an empty string if not required.

Return Value

The constructed where clause string.

Remarks

This method provides a where clause that can be used to find record in the database based on the loadpoint information in the record. The where clause will have the following form:

WHERE (DEVICE_FCID=fcid1 AND DEVICE_OID IN (OID-commalist for fcid1)) OR (DEVICE_FCID=fcid2 AND DEVICE_OID IN (OID-commalist for fcid2)) ... OR (DEVICE_FCID=fcidn AND DEVICE_OID IN (OID-commalist for fcidn)

where OID-commalist for fcidn is a comma-delimited list of the OIDs for the specified FCID. The list can contain no more than 1000 entries. If there are more than 1000 OIDs for a particular FCID, an additional where subclause for the same FCID is created until all OIDs for the FCID has been included. This method assumes (i.e. requires) that the list of devices is ordered by FCID and no additional processing time is taken by this method to sort the list.

Requirements

Target Platforms: Windows XP SP3 (32-bit and 64-bit), Windows 7 (32-bit and 64-bit)

Not all Operating Systems are supported on all products. Visit the ArcFM Solution Supported Versions page for full details.

Reference

CallbackLoadpointList Class
CallbackLoadpointList Members