Architecture

The software you are acquiring has been specially configured to run on a network, and consequently Interact Commerce Corporation grants to you the right to use the enclosed Software on a computer network provided that for each and every concurrent user on the network, you have acquired and dedicated one licensed copy of the software. iv

What’s Included. 5

“How-Do-I” support 7

Consulting Services. 7

Programming Services. 8

Conventions used in this section. 17

Syntax conventions. 17

Terminology. 18

Parameter types. 18

Special data types. 19

Date and time formats. 19

Phone formats. 20

Overview of the ACT! OLE Database Object 21

How can developers use an ACT! OLE Database Object?. 21

How does the OLE Database Object affect the ACT! user interface?. 21

Is the OLE Database Object a database tool for developing applications that can access ACT! data? 21

Features and limitations of the ACT! OLE Database Object 22

System requirements. 22

Development languages. 22

Using the Database Object with Visual C++. 22

Example VISUAL C++ code. 23

Using properties in Visual C++. 24

Understanding key files. 24

Using the type library. 25

ACT! Database Unique ID field considerations. 25

ACT! OLE Database Object definitions. 26

ACT! OLE object model 27

What’s new 28

Changes for ACT! 3.0.6. 28

Changes for ACT! 3.0.7. 29

Changes for ACT! 4.0. 29

Changes for ACT! 4.0.2. 30

Changes for ACT! 2000. 30

Common properties and methods. 34

FieldCount Property. 42

Fields Property. 43

FindDuplicates Method (requires ACT! 2000 or later) 43

GetDataEx Method (requires ACT! 4.0.2 or later) 44

GetDuplicateCriteria Method (requires ACT! 2000 or later) 46

GetSort Method (requires ACT! 4.0 or later) 47

GoTo Method. 48

IsBOF Property. 48

IsEOF Property. 49

IsLocked Property. 49

IsOpen Property. 49

Jump Method. 50

LastError Property. 50

LockLevel Property. 51

Lookup Method. 51

LookupKeyword Method. 52

MoveFirst Method. 53

MoveLast Method. 53

MoveNext Method. 53

MovePrevious Method. 54

Name Property. 54

Position Property. 54

Query Property. 55

Rebuild Method. 55

RecordCount Property. 55

SetDataEx Method (requires ACT! 4.0.2 or later) 56

SetDuplicateCriteria Method (requires ACT! 2000 or later) 57

Sort Method. 58

Update Method. 59

Activity object properties and methods. 60

Clear Method. 62

ClearClearedFilter Method. 62

ClearContactScope Method. 62

ClearDateScope Method. 63

ClearGroupScope Method. 63

ClearPriorityFilter Method. 63

ClearRecurring Method. 64

ClearTimedFilter Method. 64

ClearTimelessFilter Method. 64

ClearTypeFilter Method. 65

ClearUnclearedFilter Method. 65

ExceptionInfo Property. 65

FirstScheduledWith Property. 66

GetDaysOfMonthBits Method. 67

GetDaysOfWeekBits Method. 68

GetRecurringFrequency Method. 69

GetRecurringUntilDate Method. 70

GetWeeksOfMonthBits Method. 71

HasAlarm Method. 72

HasDetails Method (requires ACT! 2000 or later) 72

IsClear Method. 73

IsOutlookActivity Method (requires ACT! 2000 or later) 73

IsRecurring Method. 74

IsTimeless Method. 74

NextScheduledWith Property (requires ACT! 4.0 or later) 75

RecurringChangeMode Property. 76

recurringType Property. 76

SetClearedFilter Method. 77

SetContactScope Method. 77

SetDateScope Method. 78

SetGroupScope Method. 79

SetPriorityFilter Method. 79

SetRecurringDays Method. 80

SetRecurringDaysAndWeeksofMonth Method. 80

SetRecurringWeekDays Method. 82

SetTimedFilter Method. 83

SetTimeless Method. 83

SetTimelessFilter Method. 83

SetTypeFilter Method. 84

SetUnclearedFilter Method. 84

Unclear Method. 85

Contact object methods. 86

LoadLookUpQuery Method (requires ACT! 3.0.6 or later) 86

LookupMyRecord Method (requires ACT! 2000 or later) 86

SetAsMyRecord Method (requires ACT! 4.0 or later) 87

Database object properties and methods. 89

ActiveUserCount Property. 91

Activity Property. 91

ActVersion Method (requires ACT! 3.0.6 or later) 92

BeginBatchInsert Method (requires ACT! 4.0.2 or later) 92

BeginBatchUpdate Method (requires ACT! 4.0.2 or later) 93

Close Method. 95

Contact Property. 95

CurrentUser Property. 95

DatabaseVersion Method (requires ACT! 4.0 or later) 96

Email Property. 96

EndBatchInsert Method (requires ACT! 4.0.2 or later) 97

EndBatchUpdate Method (requires ACT! 4.0.2 or later) 97

GetDatabasePath Method (requires ACT! 4.0 or later) 97

GetTableId Method (requires ACT! 3.0.6 or later) 98

GetTableNameFromId Method (requires ACT! 3.0.6 or later) 99

GetTableNameFromIndex Method (requires ACT! 3.0.6 or later) 99

GetUniqueId Method. 100

Group Property. 100

IsInBatchMode Property (requires ACT! 4.0.2 or later) 100

IsLocked Property (requires ACT! 4.0.2 or later) 101

IsMultiUser Property. 101

IsOpen Property. 101

IsOpening Property. 102

Lock Method (requires ACT! 4.0.2 or later) 102

LogTransactions Property. 103

MajorVersion Property. 103

MinorVersion Property. 104

Name Property. 104

NoteHistory Property. 104

Open Method. 105

OpenEx Method (requires ACT! 4.0 or later) 105

PhoneFormatting Property. 106

Relations Property (requires ACT! 3.0.6 or later) 106

TableCount Method (requires ACT! 3.0.6 or later) 107

Unlock Method (requires ACT! 4.0.2 or later) 107

Users Property. 107

ValidateUser Method. 108

Version Property (requires ACT! 3.0.6 or later) 109

Email object methods. 110

ClearContactScope Method (requires ACT! 3.0.7 or later) 110

SetContactScope Method (requires ACT! 3.0.7 or later) 110

ExceptionInfo object properties and methods. 112

Fields object properties and methods. 115

AutoPopulate Property (requires ACT! 2000 or later) 116

BeginBatch Method (requires ACT! 4.0.2 or later) 117

Count Property. 118

DecimalPlaces Property. 119

EndBatch Method (requires ACT! 4.0.2 or later) 119

EntryRule Property (requires ACT! 4.0.2 or later) 119

EntryTrigger Property. 120

Exists Property. 121

ExitTrigger Property. 121

FieldId Property (requires ACT! 3.0.7 or later) 122

FieldIdAt Property (requires ACT! 3.0.6 or later) 122

Flags Property. 123

GetLinkToList Method (requires ACT! 2000 or later) 123

HasPopupList Property. 124

Id Property. 125

InitialValue Property. 125

IsBlockSync Property. 125

IsCutHistory Property. 126

IsIndexed Property. 126

IsPrimary Property. 127

IsSortable Property. 127

Label Property. 128

Length Property. 128

Modifiable Property. 129

POPUPINFO Property. 129

SetLinkToList Method (requires ACT! 2000 or later) 130

Type Property. 131

UnLinkLists Method (requires ACT! 2000 or later) 132

Group object properties and methods. 134

AddContact Method. 135

AddSubGroup Method (requires ACT! 2000 or later) 135

AssignParent Method (requires ACT! 2000 or later) 136

ChangeToParentGroup Method (requires ACT! 2000 or later) 137

ChangeToSubGroup Method (requires ACT! 2000 or later) 137

ClearContactScope Method (requires ACT! 3.0.7 or later) 138

ContactCount Property. 138

GetParent Method (requires ACT! 2000 or later) 139