Class AfMssql2012DbHelper
This database helper class can be used for SQL Server versions 2012 and later. It offers more robust numeric conversion than the generic SQL Server helper.
To use this class, override the extension's $driverMap property in your application config.
- CComponent
- AfBaseDbHelper
- AfMssqlDbHelper
- AfMssql2012DbHelper
Package: advancedfilters\dbhelpers
Author: Keith Burton kburton@kappasoft.net
Located at dbhelpers/AfMssql2012DbHelper.php
Author: Keith Burton kburton@kappasoft.net
Located at dbhelpers/AfMssql2012DbHelper.php
Methods summary
public
string
|
#
convertExpressionToDecimal( string $dbExpression, integer $numDigits, integer $decimalPlaces, integer $nonNumericResultValue )
Overrides the generic SQL Server implementation to make use of the TRY_CAST function added in 2012. This is a more robust solution and should be used if you only need to deal with SQL Server versions from 2012 onwards. |
Methods inherited from AfMssqlDbHelper
addRegexCondition()
,
checkRegex()
Methods inherited from AfBaseDbHelper
convertEmptyStringToNull()
,
convertNullToEmptyString()