SQLParameterInfo - cBaseSQLExecutor

Set of parameters

Function SQLParameterInfo Returns tSQLParamInfo[]

Call:

Get SQLParameterInfo to tSQLParamInfoArrayVariable

Returns full set of parameters for a parameterized query.

Call SQLSetParameter to set a parameter for a parameterized query.

The tSQLParamInfo struct is defined in cSQLExecutor.pkg:

Struct tSQLParamInfo
    String sName
    String sValue
End_Struct 

Example

tSQLParamInfo[] aParamsInfo

// Prepare the query
Send SQLPrepare of ghoSQLExecutor @SQL"SELECT
    Name,  
    City,
    Zip FROM Customer
    WHERE City = ${City}"

// Test for errors
If (not(Err)) Begin
    // Set the parameter value
    Send SQLSetParameter of ghoSQLExecutor "City" "Miami"

    // Get the parameters info
    Get SQLParameterInfo of ghoSQLExecutor to aParamsInfo

    // Process results here..
End 

SQLPrepare