ODBCSQLCode (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage properties

Properties associated with reports and controls

ODBCSQLCode

Presentation

Example

What is a query performed on a connection?

Properties for managing reports on data files accessed via an ODBC driver or via Native Connector

Limit

See also

AdjustmentMode

AllModifiableWithReportsAndQueries

BackgroundImagePrinted

BottomMargin

CaptionPeriodHeader

Certificate

EndDatePeriodDisplayed

FontAppointmentContent

InterfaceModifiableWithReportsAndQueries

RTFWithImagesAndTables

StartDatePeriodDisplayed

This content has been translated automatically. Click here to view the French version.

What is a query performed on a connection?
Properties for managing reports on data files accessed via an ODBC driver or via Native Connector
Limit

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

ODBCSQLCode (Property)

In french: ODBCCodeSQL

Available only with these kinds of connection

What is a query performed on a connection?

A query performed on a connection is a request made on data files handled via a specific ODBC driver or via a Native Connector.

When the connection is created, you have the ability to define:

the connection name
the name of data source
the user name and password
the name of database accessed (if there is more than one).

The report editor allows you to print the data coming from a query performed on a connection. All the parameters of the connection to use can be defined in the report editor or by programming with the WLanguage properties.

ODBCSQLCode is used to:

Find out the SQL code of the "query performed on a connection" (data source of report). This query is performed on one or more data files accessible via a specific ODBC driver or via an Native Connector. This query was defined during the report creation.
Modify the SQL code of the "query performed on a connection" (data source of report).

Remark: This property must be used in the opening code of report.

Example

// -- Opening code of report
RPT_Report1.ODBCConnectionName = "MyConnection"
RPT_Report1.ODBCSQLCode = "Select * from Products"
RPT_Report1.ODBCUserName = "MOORE"
RPT_Report1.ODBCPassword = "PSW"

Syntax

Finding out the code of the "Query performed on a connection" Hide the details

<Result> = <Report used>.ODBCSQLCode

<Result>: Character string

Text of the SQL query to be executed on the database accessed via a specific ODBC driver or via an Native Connector. This query must be a Select query (SELECT).

<Report used>: Report name

Name of report to use.

Modifying the code of the "Query performed on a connection" Hide the details

<Report used>.ODBCSQLCode = <New SQL Code>

<Report used>: Report name

Name of report to use.

<New SQL Code>: Character string (with quotes)

SQL code of query to run. The SQL code must be recognized by the database used. This query must be a Select query (SELECT).

Remarks

Properties for managing reports on data files accessed via an ODBC driver or via Native Connector

The various properties allowing handle to display the states on data files accessed via an ODBC driver or via an Native Connector are as follows:


ODBCSQLCode	Allows you to know and modify the SQL code of the query performed on a database accessed via an ODBC driver or via an Native Connector.
ODBCPassword	Allows to know and modify the associated password for the user authorized to access a database via an ODBC driver or via an Native Connector.
ODBCDatabaseName	Allows to know and modify the name of the database used by the query performed on a database accessed via an ODBC driver or via an Native Connector.
ODBCConnectionName	Allows to know and modify the name of the Connection used for handle a database accessed via an ODBC driver or via an Native Connector.
ODBCUserName	Allows you to know and modify the name of the user authorized to access a database via an ODBC driver or via an Native Connector.

Limit