Zip SQL Server Reference Documentation

Zip

Current Version: 11.6.0

Chilkat.Zip

Create, read, modify, encrypt, and extract ZIP archives.

Chilkat.Zip provides a comprehensive API for working with ZIP archives from files, memory, BinData, embedded resources, and Windows self-extracting EXEs. It can create new archives, open existing ZIPs, add files or in-memory data, inspect entries, extract selectively, and write the final archive to disk or memory.

Create ZIP archives

Add files, directories, strings, byte arrays, BinData, and StringBuilder content.

Open ZIPs from many sources

Open archives from disk, memory, BinData, embedded Windows resources, or Chilkat-created self-extracting EXEs.

Control stored paths

Use options such as AppendFromDir, DiscardPaths, PathPrefix, and saveExtraPath.

Extract selectively

Extract all files, matching entries, newer files, or flatten all output into a single directory.

Encryption support

Work with WinZip-compatible AES encryption and legacy Zip 2.0 password protection.

Large archive support

ZIP64 is used automatically when older ZIP limits are exceeded.

Important: Many methods update the in-memory ZIP object first. The archive is not written until a method such as WriteZip, WriteZipAndClose, WriteBd, or WriteToMemory is called.

Object Creation

DECLARE @hr int
DECLARE @zip int
EXEC @hr = sp_OACreate 'Chilkat.Zip', @zip OUT
IF @hr <> 0
BEGIN
    PRINT 'Failed to create ActiveX component'
    RETURN
END

-- ... use @zip ...

EXEC @hr = sp_OADestroy @zip

T-SQL uses the Chilkat ActiveX through the OLE Automation stored procedures. They must be enabled once on the server (EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE;), and the Chilkat ActiveX registered must match the bitness of the SQL Server instance (64-bit for a 64-bit SQL Server). To bind to a specific major version of Chilkat, append the major version number to the ProgID, such as sp_OACreate 'Chilkat.Zip.11' for Chilkat v11.*.*.

sp_OACreate returns an object token (an int) that is passed as the first argument of every sp_OAMethod, sp_OAGetProperty and sp_OASetProperty call, and released with sp_OADestroy. Objects returned by methods (such as an HttpResponse or JsonObject) are also tokens received through an int OUT parameter; they must likewise be destroyed, and the OUT parameter is NULL when the method fails to return an object. Objects passed as arguments are passed by their token. When an OLE Automation procedure itself fails (non-zero @hr), sp_OAGetErrorInfo describes the error.

Data types: strings are nvarchar(4000); integers, booleans (1 or 0) and object tokens are int; dates are datetime. In the signatures on this page, @success, @iResult, @sResult and the like are the OUT variables receiving a method's return value, @iValue / @sValue receive or supply a property value, and the remaining @ variables are the method's arguments in order.

A string returned through an OUT parameter is limited to 4000 characters. For longer values, retrieve the result as a result set into a table variable instead of an OUT parameter, for example DECLARE @tmp TABLE (outputLine ntext) followed by INSERT INTO @tmp EXEC sp_OAGetProperty @zip, 'LastErrorText'. See string length limitations for strings returned by sp_OAMethod calls.

Methods that pass or return raw byte arrays are not shown on this page, because varbinary(max) values cannot be exchanged through sp_OAMethod (see varbinary(max) limitation). Use the BinData-based alternatives (methods ending in Bd) or the base64 / hex string-encoded variants instead. Binary properties (such as LastBinaryResult) can be retrieved as a result set into a table variable, as shown in their signatures. Asynchronous (*Async) methods and event callbacks are not available from SQL Server.

Properties

AbortCurrent
EXEC sp_OAGetProperty @zip, 'AbortCurrent', @iValue OUT
EXEC sp_OASetProperty @zip, 'AbortCurrent', @iValue
Introduced in version 9.5.0.58

Stops the currently executing operation when set to 1.

  • Used to cancel long-running operations such as compression or extraction.
  • Can be triggered from another thread.
  • Automatically resets to 0 after the operation stops.

top
AppendFromDir
EXEC sp_OAGetProperty @zip, 'AppendFromDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'AppendFromDir', @sValue

Specifies a base directory when adding files to the ZIP.

  • This portion of the path is not included in stored ZIP entry paths.
  • Useful for controlling relative paths inside the archive.

For example, to add all files under c:/abc/123/myAppDir, this property could be set to c:/abc/123, and myAppDir/* would be passed to AppendFiles.

The path stored in the ZIP would begin with myAppDir/.

top
AutoRun
EXEC sp_OAGetProperty @zip, 'AutoRun', @sValue OUT
EXEC sp_OASetProperty @zip, 'AutoRun', @sValue

(Windows only, for creating self-extracting EXE's)

Specifies the name of an executable inside a self-extracting EXE that runs automatically after extraction.

top
AutoRunParams
EXEC sp_OAGetProperty @zip, 'AutoRunParams', @sValue OUT
EXEC sp_OASetProperty @zip, 'AutoRunParams', @sValue

(Windows only, for creating self-extracting EXE's)

Command-line arguments passed to the AutoRun executable.

top
AutoTemp
EXEC sp_OAGetProperty @zip, 'AutoTemp', @iValue OUT
EXEC sp_OASetProperty @zip, 'AutoTemp', @iValue

(Windows only, for creating self-extracting EXE's)

If 1, the EXE being created will automatically select and create a temporary directory for unzipping.

This property is often used together with AutoRun to create a self-extracting EXE that automatically unzips to a temporary directory and runs a setup program, such as setup.exe, without user interaction.

Note: To create a self-extracting EXE with no user interaction, set the following properties:

ExeSilentProgress = 0
ExeNoInterface = 1
ExeFinishNotifier = 0

The default value is 0.

top
CaseSensitive
EXEC sp_OAGetProperty @zip, 'CaseSensitive', @iValue OUT
EXEC sp_OASetProperty @zip, 'CaseSensitive', @iValue

Controls whether filename matching is case-sensitive.

  • Affects methods such as EntryMatching and UnzipMatching.
  • Default: 0

top
ClearArchiveAttribute
EXEC sp_OAGetProperty @zip, 'ClearArchiveAttribute', @iValue OUT
EXEC sp_OASetProperty @zip, 'ClearArchiveAttribute', @iValue

(Windows only)

If 1, clears the Windows archive attribute after files are successfully added to the ZIP.

The archive attribute indicates that a file has changed since the last backup.

The default value is 0.

top
ClearReadOnlyAttr
EXEC sp_OAGetProperty @zip, 'ClearReadOnlyAttr', @iValue OUT
EXEC sp_OASetProperty @zip, 'ClearReadOnlyAttr', @iValue

If 1, removes the read-only attribute from extracted files.

If 0, the read-only attribute remains unchanged.

The default value is 0.

top
Comment
EXEC sp_OAGetProperty @zip, 'Comment', @sValue OUT
EXEC sp_OASetProperty @zip, 'Comment', @sValue

Sets or retrieves the global ZIP file comment.

The default value is the empty string.

top
DebugLogFilePath
EXEC sp_OAGetProperty @zip, 'DebugLogFilePath', @sValue OUT
EXEC sp_OASetProperty @zip, 'DebugLogFilePath', @sValue

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.

More Information and Examples
top
DecryptPassword
EXEC sp_OAGetProperty @zip, 'DecryptPassword', @sValue OUT
EXEC sp_OASetProperty @zip, 'DecryptPassword', @sValue

Password used to extract encrypted ZIP archives.

  • Required to unzip encrypted entries.
  • Encrypted ZIP files may still be opened without a password, but their contents cannot be extracted until the correct password is provided.

The default value is the empty string.

top
DiscardPaths
EXEC sp_OAGetProperty @zip, 'DiscardPaths', @iValue OUT
EXEC sp_OASetProperty @zip, 'DiscardPaths', @iValue

If 1, removes all directory path information when adding files.

Only filenames are stored in the ZIP.

The default value is 0.

top
Encryption
EXEC sp_OAGetProperty @zip, 'Encryption', @iValue OUT
EXEC sp_OASetProperty @zip, 'Encryption', @iValue

Specifies encryption mode:

  • 0 → No encryption
  • 4 → WinZip-compatible AES encryption

Important: Encryption and PasswordProtect are mutually exclusive.

If PasswordProtect = 1, then Encryption should be 0.

The default value is 0.

top
EncryptKeyLength
EXEC sp_OAGetProperty @zip, 'EncryptKeyLength', @iValue OUT
EXEC sp_OASetProperty @zip, 'EncryptKeyLength', @iValue

Specifies the AES encryption key length.

  • Valid values: 128, 192, or 256

The default value is 128.

top
EncryptPassword
EXEC sp_OAGetProperty @zip, 'EncryptPassword', @sValue OUT
EXEC sp_OASetProperty @zip, 'EncryptPassword', @sValue

Password used when creating encrypted ZIP archives.

The default value is the empty string.

top
ExeDefaultDir
EXEC sp_OAGetProperty @zip, 'ExeDefaultDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeDefaultDir', @sValue

(Windows only, for creating self-extracting EXE's)

Default extraction directory shown in the self-extracting EXE user interface.

The default value is the empty string.

top
ExeFinishNotifier
EXEC sp_OAGetProperty @zip, 'ExeFinishNotifier', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeFinishNotifier', @iValue

(Windows only, for creating self-extracting EXE's)

If 1, displays a completion dialog after extraction finishes.

The default value is 0.

top
ExeIconFile
EXEC sp_OAGetProperty @zip, 'ExeIconFile', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeIconFile', @sValue

(Windows only, for creating self-extracting EXE's)

Path to an .ico file used as the EXE icon.

This feature is only available when the application creating the EXE is 32-bit.

The default value is the empty string.

top
ExeNoInterface
EXEC sp_OAGetProperty @zip, 'ExeNoInterface', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeNoInterface', @iValue

(Windows only, for creating self-extracting EXE's)

If 1, runs the self-extracting EXE without displaying the main user interface.

The default value is 0.

top
ExeSilentProgress
EXEC sp_OAGetProperty @zip, 'ExeSilentProgress', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeSilentProgress', @iValue

(Windows only, for creating self-extracting EXE's)

Controls whether a progress dialog is shown during extraction.

If ExeNoInterface = 0, the progress bar appears within the main dialog and this property has no effect.

The default value is 0.

top
ExeTitle
EXEC sp_OAGetProperty @zip, 'ExeTitle', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeTitle', @sValue

(Windows only, for creating self-extracting EXE's)

Title displayed in the self-extracting EXE dialog.

The default value is the empty string.

top
ExeUnzipCaption
EXEC sp_OAGetProperty @zip, 'ExeUnzipCaption', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeUnzipCaption', @sValue

(Windows only, for creating self-extracting EXE's)

Caption text displayed in the self-extracting EXE dialog.

The default value is the empty string.

top
ExeUnzipDir
EXEC sp_OAGetProperty @zip, 'ExeUnzipDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeUnzipDir', @sValue

(Windows only, for creating self-extracting EXE's)

Specifies a predefined extraction directory.

  • Supports environment variables such as %TEMP%.
  • UNC paths are not supported.

The default value is the empty string.

top
ExeWaitForSetup
EXEC sp_OAGetProperty @zip, 'ExeWaitForSetup', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeWaitForSetup', @iValue

If 1, waits for the AutoRun executable to finish before exiting.

If 0, the self-extracting EXE may exit before the AutoRun executable completes.

The default value is 1.

top
ExeXmlConfig
EXEC sp_OAGetProperty @zip, 'ExeXmlConfig', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeXmlConfig', @sValue

Allows for an XML config document to be used to specify all possible options for self-extracting EXEs. This property is a string containing the XML config document.

The XML should have this format:

<SfxConfig>
<ErrPwdTitle>Title for incorrect password dialog</ErrPwdTitle>
<ErrPwdCaption>Caption for incorrect password dialog</ErrPwdCaption>
<FinOkBtn>Text on finish notifier button</FinOkBtn>
<PwdOkBtn>Text on password challenge dialog's "OK" button.</PwdOkBtn>
<PwdCancelBtn>Text on password challenge dialog's Cancel button.</PwdCancelBtn>
<ErrInvalidPassword>Incorrect password error message.</ErrInvalidPassword>
<MainUnzipBtn>Text on main dialog's unzip button. Note: The MainUnzipLabel must also be set for this to take effect.</MainUnzipBtn>
<MainCloseBtn>Text on main dialog's quit/exit button. Note: The MainUnzipLabel must also be set for this to take effect.</MainCloseBtn>
<MainBrowseBtn>Text on main dialog's browse-for-directory button. Note: The MainUnzipLabel must also be set for this to take effect.</MainBrowseBtn>
<MainUnzipLabel>Caption displayed in main dialog.</MainUnzipLabel>
<AutoTemp>0 or 1 (Maps to the AutoTemp property)</AutoTemp>
<Cleanup>0 or 1 (If 1, extracted files are deleted after the SetupExe is run.)</Cleanup>
<Debug>0 or 1 (If 1, the EXE will not extract any files.)</Debug>
<Verbose>0 or 1 (If 1, verbose information is written to the log.)</Verbose>
<ShowFin>0 or 1 (Maps to the ExeFinishNotifier property)</ShowFin>
<ShowMain>0 or 1 (Maps to the ExeNoInterface property)</ShowMain>
<ShowProgress>0 or 1 (Maps to the ExeSilentProgress property)</ShowProgress>
<WaitForSetup>0 or 1 (Maps to the ExeWaitForSetup property)</WaitForSetup>
<Encryption>0 or 1 (1 = Yes, 0 = No)</Encryption>
<KeyLength>128|192|256</KeyLength>
<SetupExe>EXE to run after extracting. (Maps to the AutoRun property)</SetupExe>
<UnzipDir>Pre-defined unzip directory. (Maps to the ExeUnzipDir property. UNC paths, such as \\servername\path, are not supported.)</UnzipDir>
<DefaultDir>Default unzip directory to appear in the main dialog. (Maps to the ExeDefaultDir property)</DefaultDir>
<IconFile>Icon file to be used (Maps to the ExeIconFile property)</IconFile>
<MainTitle>Maps to the ExeTitle property.</MainTitle>
<MainCaption>Maps to the ExeUnzipCaption property.</MainCaption>
<FinTitle>Title for the finish notifier dialog.</FinTitle>
<FinCaption>Caption for the finish notifier dialog.</FinCaption>
<ProgressTitle>Title for the progress dialog.</ProgressTitle>
<ProgressCaption>Caption for the progress dialog.</ProgressCaption>
<PwTitle>Title for the password challenge dialog.</PwTitle>
<PwCaption>Caption for the password challenge dialog.</PwCaption>
</SfxConfig>

A self-extracting EXE can be run from the command line with the -log {logFilePath} option to create a log with information for debugging.

top
FileCount
EXEC sp_OAGetProperty @zip, 'FileCount', @iValue OUT

Number of files in the ZIP, excluding directory entries.

top
FileName
EXEC sp_OAGetProperty @zip, 'FileName', @sValue OUT
EXEC sp_OASetProperty @zip, 'FileName', @sValue

Path of the ZIP file to be written or overwritten.

The default value is the empty string.

top
HasZipFormatErrors
EXEC sp_OAGetProperty @zip, 'HasZipFormatErrors', @iValue OUT

Indicates whether minor ZIP format problems were detected when opening the ZIP archive.

top
IgnoreAccessDenied
EXEC sp_OAGetProperty @zip, 'IgnoreAccessDenied', @iValue OUT
EXEC sp_OASetProperty @zip, 'IgnoreAccessDenied', @iValue

If 1, files that cannot be read, written, or created due to filesystem permission errors are skipped.

If 0, any access-denied error causes the ZIP operation to fail.

The default value is 1.

top
LastBinaryResult
INSERT INTO @tmp EXEC sp_OAGetProperty @zip, 'LastBinaryResult'

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
EXEC sp_OAGetProperty @zip, 'LastErrorHtml', @sValue OUT

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
EXEC sp_OAGetProperty @zip, 'LastErrorText', @sValue OUT

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
EXEC sp_OAGetProperty @zip, 'LastErrorXml', @sValue OUT

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
EXEC sp_OAGetProperty @zip, 'LastMethodSuccess', @iValue OUT
EXEC sp_OASetProperty @zip, 'LastMethodSuccess', @iValue

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. Note: This property does not apply to methods that return integer values or to boolean-returning methods where the boolean does not indicate success or failure.

top
LastStringResult
EXEC sp_OAGetProperty @zip, 'LastStringResult', @sValue OUT

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
EXEC sp_OAGetProperty @zip, 'LastStringResultLen', @iValue OUT

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

top
MaxDate
EXEC sp_OAGetProperty @zip, 'MaxDate', @sValue OUT
EXEC sp_OASetProperty @zip, 'MaxDate', @sValue
Introduced in version 10.0.0

Maximum last-modified timestamp for files processed during add or extract operations.

Files having modification timestamps later than this value are skipped.

Supports ISO 8601 date/time formats, including:

  • YYYY-MM-DD
    Example: 2024-07-31
  • YYYY-MM-DDTHH:MM:SS±HH:MM
    Example: 2024-07-31T12:34:56+02:00
  • YYYY-MM-DDTHH:MM:SSZ
    Example: 2024-07-31T12:34:56Z

The default value is the empty string, meaning no maximum date restriction.

top
MaxUncompressSize
EXEC sp_OAGetProperty @zip, 'MaxUncompressSize', @iValue OUT
EXEC sp_OASetProperty @zip, 'MaxUncompressSize', @iValue
Introduced in version 9.5.0.96

Prevents extraction of files larger than the specified uncompressed size.

A value of 0 means no size limit.

The default value is 0.

top
MinDate
EXEC sp_OAGetProperty @zip, 'MinDate', @sValue OUT
EXEC sp_OASetProperty @zip, 'MinDate', @sValue
Introduced in version 10.0.0

Minimum last-modified timestamp for files processed during add or extract operations.

Supports ISO 8601 date/time formats, including:

  • YYYY-MM-DD
    Example: 2024-07-31
  • YYYY-MM-DDTHH:MM:SS±HH:MM
    Example: 2024-07-31T12:34:56+02:00
  • YYYY-MM-DDTHH:MM:SSZ
    Example: 2024-07-31T12:34:56Z

The default value is the empty string, meaning no minimum date restriction.

top
NumEntries
EXEC sp_OAGetProperty @zip, 'NumEntries', @iValue OUT

Total number of entries in the ZIP, including both files and directories.

More Information and Examples
top
OemCodePage
EXEC sp_OAGetProperty @zip, 'OemCodePage', @iValue OUT
EXEC sp_OASetProperty @zip, 'OemCodePage', @iValue

Specifies the OEM code page used for ZIP filename encoding.

Defaults to the OEM code page of the current computer.

top
OverwriteExisting
EXEC sp_OAGetProperty @zip, 'OverwriteExisting', @iValue OUT
EXEC sp_OASetProperty @zip, 'OverwriteExisting', @iValue

If 1, existing files are overwritten during extraction.

The default value is 1.

top
PasswordProtect
EXEC sp_OAGetProperty @zip, 'PasswordProtect', @iValue OUT
EXEC sp_OASetProperty @zip, 'PasswordProtect', @iValue

Indicates whether the ZIP uses legacy Zip 2.0 password protection.

This property is set automatically when a ZIP archive is opened by any of the Open* methods, such as OpenZip, OpenFromMemory, OpenBd, and related methods.

Important: PasswordProtect and Encryption are mutually exclusive.

If PasswordProtect = 1, then Encryption should be 0.

The default value is 0.

top
PathPrefix
EXEC sp_OAGetProperty @zip, 'PathPrefix', @sValue OUT
EXEC sp_OASetProperty @zip, 'PathPrefix', @sValue

Gets or sets a path prefix that is prepended to ZIP entry paths for files appended from the local filesystem.

This is useful when you want all extracted files to appear under a specific subdirectory.

This property affects only the following methods:

  • AppendFiles
  • AppendFilesEx
  • AddFile
  • AppendOneFileOrDir

The PathPrefix value is prepended to the stored ZIP path for each appended filesystem file.

For example, set PathPrefix to subdir/ so that files are stored in the ZIP with subdir/ prepended to their paths. When extracted, the files will be placed under the subdir directory.

This property does not affect entries added entirely from memory, such as entries added using:

  • AddString
  • AddData
  • AddBd
  • AddSb

For in-memory entries, the ZIP entry path is determined solely by the filename/path argument passed to the method.

The default value is the empty string.

top
PwdProtCharset
EXEC sp_OAGetProperty @zip, 'PwdProtCharset', @sValue OUT
EXEC sp_OASetProperty @zip, 'PwdProtCharset', @sValue
Introduced in version 9.5.0.73

Specifies the character encoding used to convert the decrypt password into its binary byte representation for legacy password-protected ZIP archives that use Zip 2.0 encryption.

The default value is ansi.

Other possible values include:

  • cp850
  • cp437
  • Any supported Windows or OEM code page listed at the link below.

This property applies only to older Zip 2.0 password protection and is not used for AES-encrypted ZIP archives.

top
TempDir
EXEC sp_OAGetProperty @zip, 'TempDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'TempDir', @sValue

Directory used for temporary files during ZIP operations.

When overwriting an existing ZIP file, a temporary file is used to avoid corrupting the original ZIP if an error occurs.

The default value depends on the runtime environment.

top
UncommonOptions
EXEC sp_OAGetProperty @zip, 'UncommonOptions', @sValue OUT
EXEC sp_OASetProperty @zip, 'UncommonOptions', @sValue
Introduced in version 9.5.0.84

Advanced options for uncommon scenarios.

  • ForceZip64 → Forces ZIP64 format even when not required.

The default value is the empty string.

top
VerboseLogging
EXEC sp_OAGetProperty @zip, 'VerboseLogging', @iValue OUT
EXEC sp_OASetProperty @zip, 'VerboseLogging', @iValue

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
EXEC sp_OAGetProperty @zip, 'Version', @sValue OUT

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

More Information and Examples
top
Zipx
EXEC sp_OAGetProperty @zip, 'Zipx', @iValue OUT
EXEC sp_OASetProperty @zip, 'Zipx', @iValue

If 1, creates ZIPX archives using the most appropriate compression method for each file.

The default value is 0.

top
ZipxDefaultAlg
EXEC sp_OAGetProperty @zip, 'ZipxDefaultAlg', @sValue OUT
EXEC sp_OASetProperty @zip, 'ZipxDefaultAlg', @sValue

Default compression algorithm used when creating ZIPX archives.

  • Possible values include:
    • deflate
    • ppmd
    • lzma
    • bzip2
    • deflate64

The default value is deflate.

top

Methods

AddBd
EXEC sp_OAMethod @zip, 'AddBd', @success OUT, @pathInZip, @bd
Introduced in version 11.0.0

Adds the contents of a BinData object as a new entry in the ZIP archive.

  • pathInZip specifies the filename and optional directory path stored within the ZIP.
  • The bytes contained in bd become the contents of the ZIP entry.
  • The entry is added to the in-memory ZIP object and is not written to disk until WriteZip, WriteZipAndClose, WriteBd, or WriteToMemory is called.

Returns 1 for success, 0 for failure.

More Information and Examples
top
AddEmpty
EXEC sp_OAMethod @zip, 'AddEmpty', @success OUT, @isDir, @pathInZip
Introduced in version 11.0.0

Adds an empty file or directory entry to the ZIP archive.

  • If isDir = 1, an empty directory entry is created.
  • If isDir = 0, an empty file entry is created.
  • pathInZip specifies the path stored in the ZIP archive.

This method is useful when directory structure entries must exist even if no files are present.

Returns 1 for success, 0 for failure.

top
AddEncoded
EXEC sp_OAMethod @zip, 'AddEncoded', @success OUT, @pathInZip, @encoding, @data
Introduced in version 11.0.0

Adds encoded binary data as a ZIP entry.

  • encoding specifies how data is encoded.
  • Common encodings include base64 and hex.
  • The decoded binary bytes become the contents of the ZIP entry.

This method is useful when binary data already exists in textual encoded form.

Returns 1 for success, 0 for failure.

top
AddFile
EXEC sp_OAMethod @zip, 'AddFile', @success OUT, @localPath, @saveExtraPath
Introduced in version 11.0.0

Adds a file or directory from the local filesystem to the ZIP archive.

  • If localPath is an absolute path and saveExtraPath = 1, the stored ZIP path includes the relative directory structure.
  • If saveExtraPath = 0, only the filename is stored.
  • If localPath is already relative, the relative path is stored as-is regardless of saveExtraPath.

This method adds a reference to the file or directory in the local filesystem. The file data is not immediately read or compressed.

The actual file contents are consumed only when a Write* method is called, such as:

  • WriteZip
  • WriteZipAndClose
  • WriteBd
  • WriteToMemory

This allows files and data entries to be accumulated in the in-memory ZIP object prior to writing the final ZIP archive.

Returns 1 for success, 0 for failure.

More Information and Examples
top
AddNoCompressExtension
EXEC sp_OAMethod @zip, 'AddNoCompressExtension', NULL, @fileExtension

Adds a file extension to the internal "no-compression" list.

Files having these extensions are stored without compression because they are already compressed or because compression would provide little benefit.

For example:

  • .zip
  • .jpg
  • .png
  • .gz

The extension may be specified with or without the leading dot.

Additional extensions remain active for the lifetime of the Zip object unless removed with RemoveNoCompressExtension.

top
AddSb
EXEC sp_OAMethod @zip, 'AddSb', @success OUT, @pathInZip, @sb, @charset
Introduced in version 11.0.0

Adds the contents of a StringBuilder object as a text entry in the ZIP archive.

  • The text is converted to bytes using the specified charset.
  • pathInZip specifies the filename stored in the ZIP.

Returns 1 for success, 0 for failure.

top
AddString
EXEC sp_OAMethod @zip, 'AddString', @success OUT, @pathInZip, @content, @charset
Introduced in version 11.0.0

Adds a string as a text file entry in the ZIP archive.

  • The string is converted to bytes using the specified charset.
  • pathInZip specifies the path stored within the ZIP archive.

This method is useful for dynamically generating text files directly in memory.

Returns 1 for success, 0 for failure.

More Information and Examples
top
AppendFiles
EXEC sp_OAMethod @zip, 'AppendFiles', @success OUT, @filePattern, @recurse

Adds one or more files matching a wildcard pattern.

  • The wildcard character * matches zero or more characters.
  • If recurse = 1, subdirectories are processed recursively.
  • If recurse = 0, only the current directory is searched.

For example:

AppendFiles("c:/temp/*.txt", 0)

This method only updates the in-memory ZIP object. The ZIP file itself is not written until a Write* method is called.

Returns 1 for success, 0 for failure.

top
AppendFilesEx
EXEC sp_OAMethod @zip, 'AppendFilesEx', @success OUT, @filePattern, @recurse, @saveExtraPath, @archiveOnly, @includeHidden, @includeSystem

Advanced version of AppendFiles with additional filtering and path options.

  • saveExtraPath controls whether the extra leading path information from the filePattern is preserved in the ZIP.
  • archiveOnly applies only on Windows and limits processing to files having the archive attribute set.
  • includeHidden controls whether hidden files are included.
  • includeSystem controls whether files with the System attribute are included.

This method adds references to files in the in-memory ZIP object. No ZIP file is written until a Write* method is called.

Returns 1 for success, 0 for failure.

top
AppendZip
EXEC sp_OAMethod @zip, 'AppendZip', @success OUT, @zipPath

Note: This method is currently not working and will be fixed in v11.5.0

Adds all entries from another existing ZIP archive into the current ZIP object.

The zipPath argument specifies the path of a ZIP file located in the local filesystem.

All entries from the specified ZIP archive are appended to the current in-memory ZIP object.

The ZIP archive itself is not rewritten until a Write* method is called.

This method is useful for merging the contents of multiple ZIP archives into a single ZIP.

Returns 1 for success, 0 for failure.

More Information and Examples
top
CloseZip
EXEC sp_OAMethod @zip, 'CloseZip', NULL

Closes the currently open ZIP archive and clears all entries from the Zip object.

This method has the same effect as calling NewZip without specifying a filename.

top
DeleteEntry
EXEC sp_OAMethod @zip, 'DeleteEntry', @success OUT, @entry

Removes a ZIP entry from the current ZIP object.

The ZIP file itself is not rewritten until a Write* method is called.

Returns 1 for success, 0 for failure.

top
EntryAt
EXEC sp_OAMethod @zip, 'EntryAt', @success OUT, @index, @entry
Introduced in version 11.0.0

Retrieves the ZIP entry at the specified zero-based index.

  • The first entry is at index 0.
  • The matching entry is returned in the supplied ZipEntry object.

Returns 1 for success, 0 for failure.

top
EntryById
EXEC sp_OAMethod @zip, 'EntryById', @success OUT, @id, @entry
Introduced in version 11.0.0

Finds a ZIP entry by its unique EntryID.

The matching entry is returned in the supplied ZipEntry object.

Returns 1 for success, 0 for failure.

More Information and Examples
top
EntryMatching
EXEC sp_OAMethod @zip, 'EntryMatching', @success OUT, @pattern, @entry
Introduced in version 11.0.0

Finds the first ZIP entry whose stored path matches a wildcard pattern.

  • The wildcard character * matches zero or more characters.
  • The comparison is performed against the full stored ZIP path.

Returns 1 for success, 0 for failure.

top
EntryOf
EXEC sp_OAMethod @zip, 'EntryOf', @success OUT, @pathInZip, @entry
Introduced in version 11.0.0

Finds a ZIP entry whose stored path exactly matches pathInZip.

The matching entry is returned in the supplied ZipEntry object.

Returns 1 for success, 0 for failure.

More Information and Examples
top
ExcludeDir
EXEC sp_OAMethod @zip, 'ExcludeDir', NULL, @dirName

Adds a directory name to the exclusion list used by recursive append operations.

  • All directories having the specified name are skipped.
  • The comparison is case-insensitive.
  • Call multiple times to exclude multiple directory names.

This affects methods such as AppendFiles and AppendFilesEx.

top
ExtractExe
EXEC sp_OAMethod @zip, 'ExtractExe', @success OUT, @exePath, @dirPath
Introduced in version 9.5.0.44

Extracts files from a Chilkat-created self-extracting EXE.

  • Files are extracted into dirPath.
  • Subdirectories are automatically created as needed.
  • If the EXE is encrypted, DecryptPassword must be set before extraction.

Returns 1 for success, 0 for failure.

top
GetDirectoryAsXML
EXEC sp_OAMethod @zip, 'GetDirectoryAsXML', @sResult OUT

Returns the ZIP directory structure as an XML document.

The returned XML contains information about the entries currently contained within the ZIP archive, including files and directories.

This method is useful for inspecting ZIP contents without extracting files.

Returns the XML document as a string.

Returns NULL on failure

More Information and Examples
top
GetExeConfigParam
EXEC sp_OAMethod @zip, 'GetExeConfigParam', @sResult OUT, @name

(Windows only, for creating self-extracting EXE's)

Returns the value of a configuration parameter embedded within a self-extracting EXE.

The name argument should be one of the XML tag names described in the ExeXmlConfig property documentation.

For example:

  • MainTitle
  • MainCaption
  • SetupExe

Returns the parameter value as a string.

Returns NULL on failure

top
GetMaxUncompressedSize
EXEC sp_OAMethod @zip, 'GetMaxUncompressedSize', @sResult OUT
Introduced in version 9.5.0.96

Returns the largest uncompressed file size contained within the ZIP archive.

The size is returned as a string rather than an integer because the value may exceed the range of a 32-bit integer.

This method is useful when:

  • Checking for extremely large files before extraction
  • Estimating required disk space
  • Detecting unusually large compressed entries

Returns the size as a decimal string.

Returns NULL on failure

top
IsNoCompressExtension
EXEC sp_OAMethod @zip, 'IsNoCompressExtension', @success OUT, @fileExtension

Checks whether a file extension is contained in the internal "no-compression" extension list.

Files having extensions in this list are stored without compression because they are typically already compressed.

The extension may be specified with or without the leading dot.

For example, both of the following are valid:

  • .jpg
  • jpg

Returns 1 if the extension exists in the list, otherwise returns 0.

top
IsPasswordProtected
EXEC sp_OAMethod @zip, 'IsPasswordProtected', @success OUT, @zipPath

Checks whether a ZIP archive uses legacy Zip 2.0 password protection.

The zipPath argument specifies the path of a ZIP file in the local filesystem.

This method checks only for traditional Zip 2.0 password protection.

Returns 1 if the ZIP archive is password protected, otherwise returns 0.

top
NewZip
EXEC sp_OAMethod @zip, 'NewZip', @success OUT, @zipPath

Initializes a new empty ZIP archive.

  • If another ZIP archive is currently open, it is closed.
  • All existing in-memory ZIP entries are discarded.
  • The FileName property is set to zipPath.

No ZIP file is actually created until a Write* method is called.

This method resets the Zip object to a clean empty state.

More Information and Examples
top
OpenBd
EXEC sp_OAMethod @zip, 'OpenBd', @success OUT, @binData
Introduced in version 9.5.0.66

Opens a ZIP archive contained entirely within a BinData object.

This method allows ZIP archives to be processed entirely in memory without requiring a filesystem file.

When a ZIP archive is opened:

  • PasswordProtect is automatically set if legacy Zip 2.0 encryption is detected.
  • Encryption is automatically set if strong encryption is detected.
  • A value of 4 for Encryption indicates WinZip-compatible AES encryption.

Returns 1 for success, 0 for failure.

More Information and Examples
top
OpenEmbedded
EXEC sp_OAMethod @zip, 'OpenEmbedded', @success OUT, @exeFilename, @resourceName

(Windows only)

Opens a ZIP archive embedded as a resource within a Windows executable.

  • exeFilename specifies the EXE file path.
  • resourceName specifies the embedded resource name containing the ZIP data.

This method is useful when ZIP archives are packaged within Windows applications.

Returns 1 for success, 0 for failure.

top
OpenZip
EXEC sp_OAMethod @zip, 'OpenZip', @success OUT, @zipPath

Opens a ZIP archive from the local filesystem.

The zipPath argument specifies the path of the ZIP file to open.

Encrypted ZIP archives may be opened without providing a password, but encrypted entries cannot be extracted until the correct password is provided using DecryptPassword.

When the ZIP archive is opened:

  • PasswordProtect is automatically set if legacy Zip 2.0 encryption is detected.
  • Encryption is automatically set if strong encryption is detected.
  • Encryption = 4 indicates WinZip-compatible AES encryption.

Returns 1 for success, 0 for failure.

More Information and Examples
top
QuickAppend
EXEC sp_OAMethod @zip, 'QuickAppend', @success OUT, @zipPath

Efficiently appends additional entries to an existing ZIP archive.

The zipPath argument specifies the path of an existing ZIP archive in the local filesystem.

This method avoids rewriting existing entries.

  • Existing ZIP entries remain unchanged.
  • New entries are appended to the end of the ZIP archive.
  • The ZIP central directory is updated accordingly.

This method is typically faster than rebuilding the entire ZIP archive.

Returns 1 for success, 0 for failure.

top
RemoveNoCompressExtension
EXEC sp_OAMethod @zip, 'RemoveNoCompressExtension', NULL, @fileExtension

Removes a file extension from the internal "no-compression" extension list.

After removal, files having this extension may be compressed normally.

The extension may be specified with or without the leading dot.

top
SetCompressionLevel
EXEC sp_OAMethod @zip, 'SetCompressionLevel', NULL, @level

Sets the compression level for all file and data entries currently contained within the ZIP object.

  • 0 → No compression
  • 9 → Maximum compression

The default compression level is 6.

Important: This method should be called after files or data entries have already been added to the ZIP object.

The compression level cannot be changed for mapped entries originating from an already-open ZIP archive.

top
SetExclusions
EXEC sp_OAMethod @zip, 'SetExclusions', NULL, @excludePatterns

Specifies a collection of wildcard exclusion patterns used when adding files to the ZIP archive.

Each pattern may use the wildcard character * to match zero or more characters.

Files matching any exclusion pattern are skipped.

top
SetExeConfigParam
EXEC sp_OAMethod @zip, 'SetExeConfigParam', NULL, @paramName, @paramValue

(Windows only, for creating self-extracting EXE's)

Sets a configuration parameter embedded within a self-extracting EXE created by WriteExe or WriteExe2.

The paramName should be one of the XML configuration tag names described in the ExeXmlConfig property documentation.

For example:

SetExeConfigParam("MainUnzipBtn","Extract")

This changes the text displayed on the self-extractor's main unzip button.

top
Unzip
EXEC sp_OAMethod @zip, 'Unzip', @iResult OUT, @dirPath

Extracts all files and directories from the ZIP archive.

  • dirPath specifies the destination directory.
  • Subdirectories are automatically created as needed.

Returns the number of files extracted.

Returns -1 if a failure occurs.

More Information and Examples
top
UnzipInto
EXEC sp_OAMethod @zip, 'UnzipInto', @iResult OUT, @dirPath

Extracts all files into a single directory.

All directory path information stored within the ZIP archive is ignored.

If multiple files have the same filename, later extracted files overwrite earlier ones.

Returns the number of files extracted, or -1 on failure.

top
UnzipMatching
EXEC sp_OAMethod @zip, 'UnzipMatching', @iResult OUT, @dirPath, @pattern, @verbose

Extracts only entries whose stored paths match a wildcard pattern.

  • The wildcard character * matches zero or more characters.
  • If no wildcard is used, an exact filename match is required.

Subdirectories are automatically created as needed.

Returns the number of files extracted, or -1 on failure.

More Information and Examples
top
UnzipMatchingInto
EXEC sp_OAMethod @zip, 'UnzipMatchingInto', @iResult OUT, @dirPath, @pattern, @verbose

Extracts matching entries into a single directory while ignoring all stored ZIP path information.

Matching behavior is identical to UnzipMatching.

If duplicate filenames occur, later extracted files overwrite earlier ones.

Returns the number of files extracted, or -1 on failure.

top
UnzipNewer
EXEC sp_OAMethod @zip, 'UnzipNewer', @iResult OUT, @dirPath

Extracts only files that:

  • Do not already exist
  • Or have older modification timestamps than the ZIP entry

Subdirectories are automatically created as needed.

Returns the number of files extracted, or -1 on failure.

More Information and Examples
top
VerifyPassword
EXEC sp_OAMethod @zip, 'VerifyPassword', @success OUT

Verifies that the current DecryptPassword value is correct for the currently opened ZIP archive.

This method allows password validation before attempting extraction.

Returns 1 if the password is valid, otherwise returns 0.

More Information and Examples
top
WriteBd
EXEC sp_OAMethod @zip, 'WriteBd', @success OUT, @binData
Introduced in version 9.5.0.66

Writes the ZIP archive to a BinData object instead of a filesystem file.

The generated ZIP archive exists entirely in memory.

The ZIP data written by this method may later be opened using OpenBd.

Returns 1 for success, 0 for failure.

More Information and Examples
top
WriteExe
EXEC sp_OAMethod @zip, 'WriteExe', @success OUT, @exeFilename

(Windows only, for creating self-extracting EXE's)

Creates a Windows self-extracting executable (EXE).

The generated EXE contains both the extraction logic and the ZIP archive data.

There are no limitations on:

  • Total ZIP size
  • Individual file size
  • Number of files

The generated EXE supports the following command-line arguments:

  • -log logFileName
  • -unzipDir unzipDirectoryPath
  • -pwd password
  • -ap autoRunParams

Returns 1 for success, 0 for failure.

top
WriteZip
EXEC sp_OAMethod @zip, 'WriteZip', @success OUT

Saves the Zip to a file and implictly re-opens it so further operations can continue. Use WriteZipAndClose to write and close the Zip. There is no limitation on the size of files that may be contained within a .zip, the total number of files in a .zip, or the total size of a .zip. If necessary, WriteZip will use the ZIP64 file format extensions when 4GB or file count limitations of the old zip file format are exceeded.

Returns 1 for success, 0 for failure.

More Information and Examples
top
WriteZipAndClose
EXEC sp_OAMethod @zip, 'WriteZipAndClose', @success OUT

Saves the Zip to a file and closes it. On return, the Zip object will be in the state as if NewZip had been called. There is no limitation on the size of files that may be contained within a .zip, the total number of files in a .zip, or the total size of a .zip. If necessary, WriteZip will use the ZIP64 file format extensions when 4GB or file count limitations of the old zip file format are exceeded.

Returns 1 for success, 0 for failure.

More Information and Examples
top

Deprecated

AppendBd
EXEC sp_OAMethod @zip, 'AppendBd', @zipEntry OUT, @pathInZip, @byteData -- returns a ChilkatZipEntry object token
Introduced in version 9.5.0.70
This method is deprecated and replaced by AddBd

This method is deprecated. Applications should instead call AddBd.

Appends the contents of byteData as a new entry to this zip object. The zip entry object containing the data is returned.

Returns NULL on failure

top
AppendDataEncoded
EXEC sp_OAMethod @zip, 'AppendDataEncoded', @zipEntry OUT, @filename, @encoding, @data -- returns a ChilkatZipEntry object token
Introduced in version 9.5.0.59
This method is deprecated and replaced by AddEncoded

This method is deprecated. Applications should instead call AddEncoded.

Appends in-memory data as a new entry to a Zip object. The filename is the filename of the entry as it will appear within the zip. The encoding is the encoding of the data, such as base64, hex, etc. The full list of encodings is listed at the web page linked below.

Returns the zip entry object.

Note: This method only updates the zip object. To update (rewrite) a zip file, either the WriteZip or WriteZipAndClose method would need to be called.

Returns NULL on failure

top
AppendNew
EXEC sp_OAMethod @zip, 'AppendNew', @zipEntry OUT, @fileName -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by AddEmpty

This method is deprecated. Applications should instead call AddEmpty.

Appends a new and empty entry to the Zip object and returns the ZipEntry object. Data can be appended to the entry by calling ZipEntry.AppendData.

Important: To append an already-existing file, call the AppendOneFileOrDir method. The AppendNew method inserts a new and empty file entry within the Zip object. The purpose of AppendNew is to either create an empty file within the Zip, or to create a new file entry which can then be filled with data by calling the entry's AppendData method.

Note: This method only updates the zip object. To update (rewrite) a zip file, either the WriteZip or WriteZipAndClose method would need to be called.

Returns NULL on failure

top
AppendNewDir
EXEC sp_OAMethod @zip, 'AppendNewDir', @zipEntry OUT, @dirName -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by AddEmpty

This method is deprecated. Applications should instead call AddEmpty.

Adds an entry to the zip so that when it unzips, a new directory (with no files) is created. The directory does not need to exist on the local filesystem when calling this method. The dirName is simply a string that is used as the directory path for the entry added to the zip. The zip entry object is returned.

Note: This method only updates the zip object. To update (rewrite) a zip file, either the WriteZip or WriteZipAndClose method would need to be called.

Returns NULL on failure

top
AppendOneFileOrDir
EXEC sp_OAMethod @zip, 'AppendOneFileOrDir', @success OUT, @fileOrDirPath, @saveExtraPath
This method is deprecated and replaced by AddFile

This method is deprecated. Applications should instead call AddFile.

Adds a file or directory to the object. If fileOrDirPath is an absolute file path and saveExtraPath is true, fileOrDirPath is converted to a relative file path for the zip entry. Otherwise, only the filename is stored. If fileOrDirPath is a relative file path, it is stored as-is in the zip, regardless of saveExtraPath.

Returns 1 for success, 0 for failure.

top
AppendSb
EXEC sp_OAMethod @zip, 'AppendSb', @success OUT, @pathInZip, @sb, @charset
Introduced in version 10.0.0
This method is deprecated and replaced by AddSb

This method is deprecated. Applications should instead call AddSb.

Same as AppendString, but append the contents of of the sb, and allow the charset to be specified. The contents of sb is converted to charset before being added to the zip. The pathInZip is the path of the file that will be stored within the zip.

Note: This method only updates the zip object. To update (rewrite) a zip file, either the WriteZip or WriteZipAndClose method would need to be called.

Returns 1 for success, 0 for failure.

top
AppendString
EXEC sp_OAMethod @zip, 'AppendString', @zipEntry OUT, @internalZipFilepath, @textData -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by AddString

This method is deprecated. Applications should instead call AddString.

Adds an in-memory string to the Zip object. The textData argument is converted to the ANSI charset before being added to the Zip. If the Zip were written to disk by calling WriteZip, and later unzipped, the entry would unzip to an ANSI text file.

Note: This method only updates the zip object. To update (rewrite) a zip file, either the WriteZip or WriteZipAndClose method would need to be called.

Returns NULL on failure

top
AppendString2
EXEC sp_OAMethod @zip, 'AppendString2', @zipEntry OUT, @internalZipFilepath, @textData, @charset -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by AddString

This method is deprecated. Applications should instead call AddString.

Same as AppendString, but allows the charset to be specified. The textData is converted to charset before being added to the zip. The internalZipFilepath is the path of the file that will be stored within the zip.

Note: This method only updates the zip object. To update (rewrite) a zip file, either the WriteZip or WriteZipAndClose method would need to be called.

Returns NULL on failure

top
FirstEntry
EXEC sp_OAMethod @zip, 'FirstEntry', @zipEntry OUT -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by EntryAt

This method is deprecated. Applications should instead call EntryAt.

Return the first entry in the Zip. Call ZipEntry.NextEntry to iterate over the entries in a Zip until a NULL is returned.

Returns NULL on failure

top
FirstMatchingEntry
EXEC sp_OAMethod @zip, 'FirstMatchingEntry', @zipEntry OUT, @pattern -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by EntryMatching

This method is deprecated. Applications should instead call EntryMatching.

Returns the first entry having a filename matching a pattern. The * characters matches 0 or more of any character. The full filename, including path, is used when matching against the pattern. A NULL is returned if nothing matches.

Returns NULL on failure

top
GetEntryByID
EXEC sp_OAMethod @zip, 'GetEntryByID', @zipEntry OUT, @entryID -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by EntryById

This method is deprecated. Applications should instead call EntryById.

Finds and returns the entry with the given entryID. (Each entry within the zip object has a unique EntryID.)

Returns NULL on failure

top
GetEntryByIndex
EXEC sp_OAMethod @zip, 'GetEntryByIndex', @zipEntry OUT, @index -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by EntryAt

This method is deprecated. Applications should instead call EntryAt.

Retrieves a ZipEntry by index. The first entry is at index 0. This will return directory entries as well as files.

Returns NULL on failure

top
GetEntryByName
EXEC sp_OAMethod @zip, 'GetEntryByName', @zipEntry OUT, @entryName -- returns a ChilkatZipEntry object token
This method is deprecated and replaced by EntryOf

This method is deprecated. Applications should instead call EntryOf.

Returns the entry where the file path stored within the zip equals entryName.

Returns NULL on failure

top
GetExclusions
EXEC sp_OAMethod @zip, 'GetExclusions', @stringArray OUT -- returns a CkStringArray object token
This method is deprecated.

This method is deprecated and will removed in a future version of Chilkat.

Returns the current collection of exclusion patterns that have been set by SetExclusions.

Returns NULL on failure

top
SetPassword
EXEC sp_OAMethod @zip, 'SetPassword', NULL, @password
This method is deprecated.

Sets both the decrypt password and encrypt password.

This method affects:

  • DecryptPassword
  • EncryptPassword

Note: This method is deprecated in favor of setting DecryptPassword and EncryptPassword separately.

top