InsertArray

Purpose
Used to insert a new record into the database.

Syntax (Method)
object.Insert Key, Data, KeyBefore, InstanceBefore

Parameters
Key (String)   The new record's key is assigned this value.
Data (String)   The new record's data is assigned this value.
KeyBefore (String)   The new record is inserted just before the InstanceBefore instance of an existing record containing this key.
InstanceBefore (Long)   The new record is inserted just before this instance of an existing record containing KeyBefore.

Notes
This method allows duplicate keys to exist in the database. Hence, if this method is called with a key (Key) that already exists in the database, a new record will still be inserted with the specified key (Key).

Error Values
After calling this method, the property ErrorNumber will report one of the following values:

rtCDP_ErrNoError
rtCDP_ErrKeyTooLong
rtCDP_ErrDataTooLong
rtCDP_ErrRecordNotFound
rtCDP_ErrDatabaseFull

Example
Objective: Insert some records into the database.

'Create the object
Dim CDP As rtCDP.rtCompactDataPak
Set CDP = New
rtCDP.rtCompactDataPak
'Append a new record
CDP.Append "Name", "Susan"

This is the current state of the database:

Rec Key Data
0 Name Susan

'Insert a new record
CDP.InsertArray "Name", "Dena", "Name", 0

This is the current state of the database:

Rec Key Data
0 Name Dena
1 Name Susan

'Insert a new record
CDP.Insert "Name", "Liz", "Name", 1

This is the current state of the database:

Rec Key Data
0 Name Dena
1 Name Liz
2 Name Susan

Version History
1.0 2/2/2001 Tested

See Also
Insert, InsertB, InsertArrayB, InsertRec, InsertRecB