SQLParameterInfo - cBaseSQLExecutor

Returns full set of parameters for a parameterized query

Type: Function
Return Data Type: tSQLParamInfo[]

Syntax

Function SQLParameterInfo Returns tSQLParamInfo[]

Call Example

Get SQLParameterInfo to tSQLParamInfo[]Variable

Description

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

See Also

SQLPrepare

Return Value

Set of parameters