StringTable ActiveX Reference Documentation

StringTable

Current Version: 10.1.2

A memory efficient class for holding a large number of strings (accessible by index). The primary use is as a read-only table of strings that is built once and then used by the application.

This class is introduced in Chilkat v9.5.0.62.

Object Creation

Note:
For versions of Chilkat < 10.0.0, use "Chilkat_9_5_0.StringTable" instead of "Chilkat.StringTable"
For a specific major version, use "Chilkat.StringTable.<major_version>", such as "Chilkat.StringTable.10" for Chilkat v10.*.*
See Chilkat ActiveX Object Creation

(ASP)
set obj = Server.CreateObject("Chilkat.StringTable")

(AutoIt)
$obj = ObjCreate("Chilkat.StringTable")

(Visual Basic 6.0)
Dim obj As New ChilkatStringTable

(VBScript)
set obj = CreateObject("Chilkat.StringTable")

(Delphi)
obj := TChilkatStringTable.Create(Self);

(FoxPro)
loObject = CreateObject('Chilkat.StringTable')

(PowerBuilder)
lole_object = create oleobject
li_rc = lole_object.ConnectToNewObject("Chilkat.StringTable")

(SQL Server)
EXEC @hr = sp_OACreate 'Chilkat.StringTable', @obj OUT

(Javascript)
var obj = new ActiveXObject("Chilkat.StringTable");

Properties

Count
Count As Long (read-only)
Introduced in version 9.5.0.62

The number of strings in the table.

top
DebugLogFilePath
DebugLogFilePath As String

If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. This logging helps identify the context and history of Chilkat calls leading up to any crash or hang, aiding in debugging.

Enabling the VerboseLogging property provides more detailed information. This property is mainly used for debugging rare instances where a Chilkat method call causes a hang or crash, which should generally not happen.

Possible causes of hangs include:

  • A timeout property set to 0, indicating an infinite timeout.
  • A hang occurring within an event callback in the application code.
  • An internal bug in the Chilkat code causing the hang.

top
LastBinaryResult
LastBinaryResult As Variant (read-only)

This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. It is only accessible if Chilkat.Global.KeepBinaryResult is set to 1. This feature allows for the retrieval of large varbinary results in an SQL Server environment, which has restrictions on returning large data via method calls, though temp tables can handle binary properties.

top
LastErrorHtml
LastErrorHtml As String (read-only)

Provides HTML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

top
LastErrorText
LastErrorText As String (read-only)

Provides plain text information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

top
LastErrorXml
LastErrorXml As String (read-only)

Provides XML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

top
LastMethodSuccess
LastMethodSuccess As Long

Indicates the success or failure of the most recent method call: 1 means success, 0 means failure. This property remains unchanged by property setters or getters. This method is present to address challenges in checking for null or Nothing returns in certain programming languages.

top
LastStringResult
LastStringResult As String (read-only)

In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. It is accessible only when Chilkat.Global.KeepStringResult is set to TRUE. SQL Server has limitations on string lengths returned from methods and properties, but temp tables can be used to access large strings.

top
LastStringResultLen
LastStringResultLen As Long (read-only)

The length, in characters, of the string contained in the LastStringResult property.

top
VerboseLogging
VerboseLogging As Long

If set to 1, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. The default value is 0. Verbose logging should only be used for debugging. The potentially large quantity of logged information may adversely affect peformance.

top
Version
Version As String (read-only)

Version of the component/library, such as "10.1.0"

top

Methods

Append
Append(value As String) As Long
Introduced in version 9.5.0.62

Appends a string to the table.

Returns 1 for success, 0 for failure.

top
AppendFromFile
AppendFromFile(ByVal maxLineLen As Long, charset As String, path As String) As Long
Introduced in version 9.5.0.62

Appends strings, one per line, from a file. Each line in the path should be no longer than the length specified in maxLineLen. The charset indicates the character encoding of the contents of the file, such as "utf-8", "iso-8859-1", "Shift_JIS", etc.

Returns 1 for success, 0 for failure.

top
AppendFromSb
AppendFromSb(sb As ChilkatStringBuilder) As Long
Introduced in version 9.5.0.62

Appends strings, one per line, from the contents of a StringBuilder object.

Returns 1 for success, 0 for failure.

top
Clear
Clear()
Introduced in version 9.5.0.62

Removes all the strings from the table.

top
FindSubstring
FindSubstring(ByVal startIndex As Long, substr As String, ByVal caseSensitive As Long) As Long
Introduced in version 9.5.0.77

Return the index of the first string in the table containing substr. Begins searching strings starting at startIndex. If caseSensitive is 1, then the search is case sensitive. If caseSensitive is 0 then the search is case insensitive. Returns -1 if the substr is not found.

top
GetStrings
GetStrings(ByVal startIdx As Long, ByVal count As Long, ByVal crlf As Long) As String
Introduced in version 9.5.0.87

Return the number of strings specified by count, one per line, starting at startIdx. To return the entire table, pass 0 values for both startIdx and count. Set crlf equal to 1 to emit with CRLF line endings, or 0 to emit LF-only line endings. The last string is emitted includes the line ending.

Returns Nothing on failure

top
IntAt
IntAt(ByVal index As Long) As Long
Introduced in version 9.5.0.63

Returns the Nth string in the table, converted to an integer value. The index is 0-based. (The first string is at index 0.) Returns -1 if no string is found at the specified index. Returns 0 if the string at the specified index exist, but is not an integer.

top
SaveToFile
SaveToFile(charset As String, ByVal bCrlf As Long, path As String) As Long
Introduced in version 9.5.0.62

Saves the string table to a file. The charset is the character encoding to use, such as "utf-8", "iso-8859-1", "windows-1252", "Shift_JIS", "gb2312", etc. If bCrlf is 1, then CRLF line endings are used, otherwise LF-only line endings are used.

Returns 1 for success, 0 for failure.

top
Sort
Sort(ByVal ascending As Long, ByVal caseSensitive As Long) As Long
Introduced in version 9.5.0.87

Sorts the strings in the collection in ascending or descending order. To sort in ascending order, set ascending to 1, otherwise set ascending equal to 0.

Returns 1 for success, 0 for failure.

top
SplitAndAppend
SplitAndAppend(inStr As String, delimiterChar As String, ByVal exceptDoubleQuoted As Long, ByVal exceptEscaped As Long) As Long
Introduced in version 9.5.0.62

Splits a string into parts based on a single character delimiterChar. If exceptDoubleQuoted is 1, then the delimiter char found between double quotes is not treated as a delimiter. If exceptEscaped is 1, then an escaped (with a backslash) delimiter char is not treated as a delimiter.

Returns 1 for success, 0 for failure.

top
StringAt
StringAt(ByVal index As Long) As String
Introduced in version 9.5.0.62

Returns the Nth string in the table. The index is 0-based. (The first string is at index 0.)

Returns Nothing on failure

top