SqlUtilEnumerateIntFiles - cDbUpdateFunctionLibrary

To enumerate intermediate files (*.int) in a Data folder. Instead of using the function directly you may consider using the SqlUtilChangeIntFilesToUseConnectionIDs procedure that in turn uses this function.

Type: Function

Parameters: String sDataPath

Syntax

Function SqlEnumerateIntFiles String sDataPath

Description

Use it to enumerate intermediate files within a Data folder. Returns a string array with all files except for driver files (aka MSSQLDRV.int, DB2_DRV.int and ODBC_DRV.int).

Example

Procedure OnClick

    String[] aFileData

    String sPath

    Integer iSize iCount

    Get psDataPath of (phoWorkspace(ghoApplication)) to sPath

    Get SqlEnumerateIntFiles sPath to aFileData

    Move (SizeOfArray(aFileData)) to iSize

    Decrement iSize

    For iCount from 0 to iSize

        Showln "Intermediate file name = " aFileData[iCount]        

    Loop

End_Procedure