%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... —

Query Builder Registry Settings

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