| Class: Listings-MLS Counter Handling |
| How to Read: Property/Method(Parameter As Type, ...) As ReturnValue |
| Properties |
| MLSCountID() As Long Purpose: Return MLS Count Record ID |
| MLSCountID(RecordID As Long) Purpose: Set MLS Count Record ID to update a specific record |
| CountMLS() As Long Purpose: Return MLS Number |
| CountMLS(MLSNumber As Long) Purpose: Set MLS Number for record update |
| PageTypeID() As Long Purpose: Return Page Type ID |
| PageTypeID(ID As Long) Purpose: Set Page Type ID to update a specific record |
| PageTitleID() As Long Purpose: Return Page Title ID |
| PageTitleID(ID As Long) Purpose: Set Page Title ID to update a specific record |
| SubTitleID() As Long Purpose: Return Sub Title ID |
| SubTitleID(ID As Long) Purpose: Set Sub Title ID to update a specific record |
| EntryDate() As String Purpose: Return Entry Date |
| MLSCount() As Long Purpose: Return Counts for MLS |
| MLSCount(TotalCount As Long) Purpose: Set MLS Count to update a specific record |
| MLSTotalCount() As Long Purpose: Return Total of Counts after calling GetCounters() |
| QueryStartDate(StartDate As String) Purpose: Set Start Date for query GetCounters() |
| QueryEndDate(EndDate As String) Purpose: Set End Date for query GetCounters() |
| CountIndex() As Integer Purpose: Return current Count Index |
| MLSCounterCount() As Integer Purpose: Return Counter Count after calling GetCounters() |
| Methods |
| GetCounters() As Boolean Purpose: Search DB for Counter records Set criteria using the MLS Count properties: MLSCountID(RecordID As Long) - OR - CountMLS(MLSNumber As Long) PageTypeID(ID As Long) PageTitleID(ID As Long) SubTitleID(ID As Long) QueryStartDate(StartDate As String) QueryEndDate(EndDate As String) Use CountByIndex() to retrieve records by Index [ 1 to MLSCounterCount() ] Requires: MLS Number Returns: True - successful; False - error or no records were found |
| CountByIndex(Index As Integer) As Boolean Purpose: Return Counter data for a given Index after calling GetCounters() Requires: Index - number between 1 and MLSCounterCount() Returns: True - successful; False - error |
| UpdateMLSCount() As Boolean Purpose: Update DB MLS Count given MLS - Set values using the MLS Count properties: CountMLS(MLSNumber As Long) PageTypeID(ID As Long) PageTitleID(ID As Long) SubTitleID(ID As Long) Returns: True - successful; False - error |
| ResetCounterVars() Purpose: Reset all MLS variables |