dark_mode EN
  • Method WMariaDbDatasource :BuildSQLSt
  • Parameters
    cSql

    SQL string to integrate
    xParams

    Parameters to integrate. This can be any number of additional parameters you want or an array that includes all the parameters to integrate.
  • Return value
    cString

    SQL result string.

This method allows you to integrate multiple values ​​of any type into a single SQL statement, as indicated below in the method itself.

To perform the integration, the SQL statement must include the '?' character as many times as the number of parameters you want to integrate. The method converts all passed parameters to character type, taking into account the way the engine needs to receive them. This is illustrated more clearly by an example:


oDS:BuildSqlSt( "SELECT * FROM Customers WHERE name=? and age between ? and ?", "peter", 40, 50 )

Previous chevron_left Next chevron_right