SQL Server

Determine File Type

See more FileAccess Examples

Demonstrates how to determine the type of file. Possible types are:

• 1: Regular file
• 2: Directory
• 3: Symbolic Link
• 4: Windows shortcut
• 99: Something else
• 0: File not found
• -1: Unable to check because of directory permissions or other error.

Note: This example requires Chilkat v9.5.0.77 or greater.

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    --  Call the FileType method to determine the file type.
    --  (Note: FileType is a method, not a property.)

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

    DECLARE @fileType int
    EXEC sp_OAMethod @fac, 'FileType', @fileType OUT, 'qa_data/shortcuts/chilkat_pkcs7_shortcut.xml'

    PRINT 'fileType = ' + @fileType

    --  Possible fileType values are:
    --  1: Regular file
    --  2:  Directory
    --  3: Symbolic Link
    --  4: Windows shortcut
    --  99: Something else
    --  0: File not found
    --  -1: Unable to check because of directory permissions or other error.

    EXEC @hr = sp_OADestroy @fac


END
GO