%META:TOPICPARENT{name="UDATroubleshootingAppProblems"}% ==Application Specific Problems== ===Query Builder Registry Settings===
Found on the Crystal .NET Blog — Sample codes, tips, random rantings on Crystal Reports, Crystal Enterprise etc... —
These are the registry settings of querybuilder. The numbers in brackets are the corresponding strings:
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\JoinBuilder
Registry Key | String | List of drivers that... | Syntax, if applicable |
SQLServerJoinBuilder | 201 | support SQL Server ANSI join syntax | FROM A LEFT OUTER B ON A.a = B.b |
InformixJoinBuilder | 202 | support Informix join syntax | FROM A, OUTER B WHERE A.a = B.b |
OracleJoinBuilder | 203 | support Oracle join syntax | FROM A, B WHERE A.a(+) = B.b |
OracleJoinBuilder2 | 204 | support Oracle ANSI join syntax except the FULL OUTER join. These drivers use Outer Join Escape Sequence {oj ...} even for inner joins. | FROM A LEFT OUTER B ON A.a = B.b |
SybaseJoinBuilder | 205 | support Sybase ANSI join syntax except the FULL OUTER join. | FROM A LEFT OUTER B ON A.a = B.b |
DB2JoinBuilder | 206 | support DB2 ANSI join syntax | FROM A LEFT OUTER B ON A.a = B.b |
LotusNotesJoinBuilder | 207 | support Lotus Notes join syntax | inner joins — FROM A, B WHERE A.a = B.b left outer joins — FROM A LEFT OUTER B ON A.a = B.b right outer joins — FROM B LEFT OUTER A ON A.a = B.b |
StarEqualJoinBuilder | 208 | support Sybase Star-Equal join syntax | FROM A, B WHERE A.a *= B.b |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder
Registry Key | String | List of drivers that... | Syntax, if applicable |
SQLServerNameBuilder | 301 | support SQL Server naming conventions | "<StoredProcedureName>";<Number> |
InformixNameBuilder | 302 | support Informix naming conventions | Table qualifier appears at the beginning of the fully qualified table name |
OracleNameBuilder | 303 | support Oracle naming conventions | "<Package Name>"."<Stored Procedure Name>" |
SybaseNameBuilder | 304 | support Sybase naming conventions | |
AccessNameBuilder | 305 | support Access naming conventions | Quotations are allowed in table names and kept as they are |
DB2NameBuilder | 306 | support DB2 naming conventions |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder
Registry Key | String | List of drivers that... | Syntax, if applicable |
DoubleQuotation | 601 | use double quotations to quote names | " " |
BackQuotation | 602 | use back quotations to quote names | ` ` |
SquareBracket | 603 | use square brackets to quote names | [ ] |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder
Registry Key | String | List of drivers that... | Syntax, if applicable |
Dot | 604 | use dot as qualifier separator character | . |
AtSign | 605 | use At sign as qualifier separator character | @ |
Colon | 606 | use colon as qualifier separator character | : |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\ValueBuilder
Registry Key | String | List of drivers that... | Syntax, if applicable |
SQLServerValueBuilder | 401 | support SQL Server value building conventions | Unicode strings prefixed with "N" |
SQLServer65ValueBuilder | 402 | support SQL Server 6.5 value building conventions | Unicode strings are not prefixed with "N" |
InformixValueBuilder | 403 | support Informix value building conventions | Boolean values are 'T' and 'F' |
OracleValueBuilder | 404 | support Oracle value building conventions | Using TO_DATE function to convert date to string |
OracleValueBuilder2 | 405 | support Oracle value building conventions | Unicode strings are prefixed with "N" |
SybaseValueBuilder | 406 | support Sybase value building conventions | Unicode strings are prefixed with "N" |
AccessValueBuilder | 407 | support Access value building conventions | Boolean values are 'TRUE' and 'FALSE' |
DAOAccessValueBuilder | 408 | support DAO Access value building conventions | Wild cards are * and ? |
DB2ValueBuilder | 409 | support DB2 value building conventions |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\OuterJoinEscSeq
Registry Key | String | List of drivers that... | Syntax, if applicable |
MSOuterJoinEscSeq | 501 | support Microsoft ODBC join escape sequence | {oj ...} |
NoOuterJoinEscSeq | 504 | do not support any join escape sequence |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\DateTimeEscSeq
Registry Key | String | List of drivers that... | Syntax, if applicable |
MSDateTimeEscSeq1 | 502 | support Microsoft ODBC date-time escape sequences | {ts ...}, {d ...} and {t ...} |
MSDateTimeEscSeq2 | 503 | support Microsoft Access date-time escape sequence | # ... # |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\StoredProcedureClauseBuilder
Registry Key | String | List of drivers that... | Syntax, if applicable |
DefaultStoredProcedureClauseBuilder | 701 | support default procedure calling syntax | {CALL <procedure name>(<parameters list>)} |
SQLServerStoredProcedureClauseBuilder | 702 | support Microsoft SQL Server procedure calling syntax. | <procedure name> <parameters list> |
InformixStoredProcedureClauseBuilder | 703 | support Informix calling syntax | EXECUTE PROCEDURE <procedure name>(<parameters list>) |
OracleStoredProcedureClauseBuilder | 704 | support Oracle calling syntax | BEGIN <procedure name>(<parameters list>) END |
SybaseStoredProcedureClauseBuilder | 705 | support Sybase procedure calling syntax | EXEC <procedure name> <parameters list> |
AccessStoredProcedureClauseBuilder | 706 | support Access stored procedure calling syntax | |
DB2StoredProcedureClauseBuilder | 707 | support DB2 stored procedure calling syntax | |
PSFTStoredProcedureClauseBuilder | 708 | support PeopleSoft stored procedure calling syntax |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\UnicodeConversionOptions
Registry Key | String | List of drivers that... | Syntax, if applicable |
AlwaysUnicodeConversion | 901 | always require Unicode strings to be prefixed with "N" |
HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\WhereClauseBuilder
Registry Key | String | List of drivers that... | Syntax, if applicable |
SybaseWhereClauseBuilder | 1001 | support Sybase where clause building conventions |