SqlUtilEnumerateSchemas - cDbUpdateFunctionLibrary

Enumerates SQL schemas for the passed driver ID.


Type: Function


Parameters: String sDriverID

Parameter

Description

sDriverID

DB2_DRV_ID, ORAFLEX or MDSPgSQL


Syntax


Function SQLUtilEnumerateSchemas String sDriverID Returns String[]

Call:

Get SQLUtilEnumerateSchemas DB2_DRV_ID to sMyArray



Description

Use it to retrieve all SQL schemas from an SQL database server . The return value is a string array.



Example


Procedure Activating

      tDataSourceRow[] MyData

      Handle hoDataSource

      String[] sValueArray  

      String sDriverID                                          

      Integer iCount iSize

           

      Send Cursor_Wait of Cursor_Control

      Forward Send Activating

           

      Get psDriverID to sDriverID

      Send Ignore_Error of Error_Object_Id DFERR_CANT_LOAD_DLL

      Load_Driver sDriverID

      Send Trap_Error of Error_Object_Id DFERR_CANT_LOAD_DLL

      If (LastErr = 4255) Begin

          Send Info_Box ("Can't display any items because the database driver could not be loaded. (" + sDriverID + ")")

            Procedure_Return

      End

           

      Get SqlUtilEnumerateSchemas of ghoDbUpdateFunctionLibrary sDriverID to sValueArray

     

      Move (SizeOfArray(sValueArray)) to iSize

      Decrement iSize

      For iCount from 0 to iSize

            Move sValueArray[iCount] to MyData[iCount].sValue[0]

      Loop

           

      Get phoDataSource to hoDataSource

      Send InitializeData of hoDataSource MyData

      Send Cursor_Ready of Cursor_Control

End_Procedure