SQL Server

Demonstrate Directory Path Functions

Demonstrates the path functions GetDirectoryName, GetExtension, GetFileName, and GetFileNameWithoutExtension. SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @fac int
    EXEC @hr = sp_OACreate 'Chilkat.FileAccess', @fac OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Note: Chilkat accepts either forward slash or backslash chars as directory separators..
    EXEC sp_OAMethod @fac, 'GetDirectoryName', @sTmp0 OUT, '/MyDir/MySubDir/myfile.ext'
    PRINT @sTmp0
    EXEC sp_OAMethod @fac, 'GetDirectoryName', @sTmp0 OUT, '/MyDir/MySubDir'
    PRINT @sTmp0
    EXEC sp_OAMethod @fac, 'GetDirectoryName', @sTmp0 OUT, '/MyDir/'
    PRINT @sTmp0
    EXEC sp_OAMethod @fac, 'GetDirectoryName', @sTmp0 OUT, '/MyDir'
    PRINT @sTmp0
    EXEC sp_OAMethod @fac, 'GetDirectoryName', @sTmp0 OUT, '/'
    PRINT @sTmp0

    EXEC sp_OAMethod @fac, 'GetExtension', @sTmp0 OUT, 'C:/mydir.old/myfile.ext'
    PRINT @sTmp0
    EXEC sp_OAMethod @fac, 'GetExtension', @sTmp0 OUT, 'C:/mydir.old/'
    PRINT @sTmp0

    EXEC sp_OAMethod @fac, 'GetFileName', @sTmp0 OUT, 'C:/mydir/myfile.ext'
    PRINT @sTmp0
    EXEC sp_OAMethod @fac, 'GetFileName', @sTmp0 OUT, 'C:/mydir/'
    PRINT @sTmp0

    EXEC sp_OAMethod @fac, 'GetFileNameWithoutExtension', @sTmp0 OUT, 'C:/mydir/myfile.ext'
    PRINT @sTmp0
    EXEC sp_OAMethod @fac, 'GetFileNameWithoutExtension', @sTmp0 OUT, 'C:/mydir/'
    PRINT @sTmp0


    PRINT '---'

    EXEC @hr = sp_OADestroy @fac


END
GO