PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • What is a query performed on a connection?
  • Properties used to manage reports based on data files accessed via an ODBC driver or a Native Connector
  • Limit
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures

What is a query performed on a connection?

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

When the connection is created, you can define:
  • the connection name
  • the name of the data source
  • the user name and password
  • the name of the 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.
The ODBCPassword property is used to:
  • Identify the password used to connect to a database via an ODBC driver or a Native Connector. This password is associated with a user and it must be specified when printing a report based on a "query performed on a connection".
  • Specify the password used to connect to a database via an ODBC driver or a Native Connector. This password is associated with a user and it must be specified when printing a report based on a "query performed on a connection".
Remark: This property must be used in the opening code of the 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

Identifying the password used to connect to a database via an ODBC driver or a Native Connector Hide the details

<Result> = <Report used>.ODBCPassword
<Result>: Character string
Password defined in the report to connect to a database via an ODBC driver or a Native Connector.
<Report used>: Report name
Name of the report to be used.

Specifying the password to connect to a database via an ODBC driver or a Native Connector Hide the details

<Report used>.ODBCPassword = <New password>
<Report used>: Report name
Name of the report to be used.
<New password>: Character string (with quotes)
Password to connect to the database via an ODBC driver or a Native Connector. This password must be the password defined when the connection was created.
Remarks

Properties used to manage reports based on data files accessed via an ODBC driver or a Native Connector

The following properties are used to manage reports based on data files accessed via an ODBC driver or a Native Connector:
ODBCSQLCodeUsed to identify and change the SQL code of the query executed on a database accessed via an ODBC driver or a Native Connector.
ODBCPasswordUsed to identify and change the password associated with the user allowed to access a database via an ODBC driver or a Native Connector.
ODBCDatabaseNameUsed to identify and change the name of the database used by the query executed on a database accessed via an ODBC driver or a Native Connector.
ODBCConnectionNameUsed to identify and change the name of the connection used to handle a database accessed via an ODBC driver or a Native Connector.
ODBCUserNameUsed to identify and change the name of the user allowed to access a database via an ODBC driver or a Native Connector.

Limit

The ODBCPassword property only applies to the reports based on a "query performed on a connection".
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment