CWhere Provide correct strings for Unicode SQL statements
Download

CWhere Ranking & Summary

CWhere Tags

Create Creator SQL statement SQL statement creator create SQL statement string creator

CWhere Description

The CWhere demo application uses a class will provide correct strings for Unicode SQL statements.The class implements various methods to create the final string. Basically it all ends in providing several conversions of various datatypes to strings.Currently the class contains all functions needed to create the following kind of clauses: - "fieldXY IS NULL" - "fieldXY exp value" where exp is any valid SQL operator (, =,...) - "fieldXY BETWEEN value1 AND value2" Also, these clauses can be cascaded with AND and OR statements. The class takes care of nice SQL formatting, paranthesis, brackets and spaces. You can immediately use the resulting string for concatenation or other string operations. It contains leading and trailing spaces and all expressions are enclosed in brackets.The class will provide correct strings for Unicode SQL statements too when the application is compiled using the UNICODE define.

CWhere Related Software