Smartsite Documentatie > SXML > Vipers > Global Viper Methods > Database Viper Class > Database.Preparse Viper Method

Collapse All Expand All

SCAS Level

Preparses the query the way it will be preparsed normally before the query is send to the database.

Syntax

Smartsite SXML	Copy Code
string database.preparse(string query) string database.preparse(string connectionId, string query)

Parameters

Name	Data Type	Description
query	String	The query that will be preparsed.
connectionId	String	The connection id of a databsae connection.

Return Value

Data Type	Description
String	Returns the query after it has been processed by the Query Preparser.

Remarks

The Query Preparser attempts to convert SqlServer queries to Oracle queries and the other way around.

The Query Preparser isn't able to convert all possible sql queries but it can convert many small common

differences. This helps when you are having problems executing queries in a cross dbms site.

Example

Database Preparse Example

This viper method can be used to test how an sqlquery will be preparsed by the Database layer before it is passed on to the DBMS. This viper method is especially useful if you are writing sqlqueries for an Oracle database because the preparser does the most work trying to make SqlServer queries work under Oracle without modifications. The preparser does hardly any work to make Oracle queries run under SqlServer.

Smartsite SXML	Copy Code
{database.preparse(My_OracleDb, "select top 5 Loginname, isnull(Email, '(No email)') from dbo.Users")}