Public Static (Shared) Methods
  FixNamesFor_NON_MROLEDB_Target_GENERICOLEDB | Appends an extra " for field names This is neccessary for non Microsoft NON MROLEDB targets |
| FixNamesFor_NON_MROLEDB_Target_MSSQL | Add square brackest around the variable name and appends an extra "]" for field names that contain [] (Grids, Loops, Compounds, Classes) This is neccessary for NON MROLEDB targets of type Microsoft SQL server |
| FixTextValuesFor_NON_MROLEDB_Targets | Escape single quotes. E.g. replace single quotes with double quotes |
| FixValuesFor_NON_MROLEDB_Targets | Replaces occurences of "," with "." in fields of type mtDouble |
| GetSelectString | Returns the SELECT part of and SQL statement |
| GetSelectTable | Returns the SELECT part of and SQL statement |
| GlobalSQLVariablesStringCollection | Converts an SQL statement into a string collection of GlobalSQLVariables |
| RemoveConditionClause | Remove the where clause and returns the pure select statement |
| RemoveWhereClause | Removes the where clause and returns the pure select statement |
| SQLToVariableStringCollection | Converts an SQL statement into a string collection of variables |
| VariableStringCollectionToSQL | Turns a variable list in a StringCollection into an SQL statement |
Public Instance Constructors
|
SQLStatementUtil Constructor
|
Initializes a new instance of the SQLStatementUtil class. |
Public Instance Methods
| Equals (inherited from Object) | |
| GetHashCode (inherited from Object) | |
| GetType (inherited from Object) | |
| ToString (inherited from Object) |
See Also
SQLStatementUtil Class | SPSSMR.Data Namespace