Click or drag to resize
SqlHelper Fields

The SqlHelper type exposes the following members.

Fields
  NameDescription
Public fieldStatic memberCOLUMNS_ALL
Represents all columns within given query
Public fieldStatic memberCommentsRegEx
Regex matching comments within a SQL query
Public fieldStatic memberDEFAULT_DB_SCHEMA
Default db schema.
Public fieldStatic memberDefaultSQLInlineLimit
Default inline limit for SQL lists. When the number of values is below this number, the lists on SQL, e.g. IN (x, y, z), are evaluated as inline lists.
Public fieldStatic memberGENERAL_DELETE
General delete SQL statement
Public fieldStatic memberGENERAL_INSERT
General insert SQL statement
Public fieldStatic memberGENERAL_SELECT
General select SQL statement
Public fieldStatic memberGENERAL_UPDATE
General update SQL statement
Public fieldStatic memberGENERAL_UPSERT
General upsert (update/insert) SQL statement
Public fieldStatic memberMAX_PARAM_LENGTH
Maximum parameter length to log.
Public fieldStatic memberMISSING_VALUE
Unknown value.
Public fieldStatic memberNO_COLUMNS
Constant for no columns.
Public fieldStatic memberNO_DATA_WHERE
Where condition representing no data.
Public fieldStatic memberNO_TOTALRECORDS
Value for total records input to not get the total amount of data.
Public fieldStatic memberORDERBY_ASC
Suffix for the ascending order
Public fieldStatic memberORDERBY_DESC
Suffix for the descending order
Public fieldStatic memberSELECT_NULL
Empty select statement
Top
See Also