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

Parameter

Description

sDataPath

The path to a Data folder


Syntax


Function SqlEnumerateIntFiles String sDataPath


Call:

Get SqlEnumerateIntFiles sDataPath to aFilesData



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