PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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
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 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.
ODBCPassword is used to:
  • Know the password used to connect to a database via an ODBC driver or via an 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 via 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 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

Know the password used to connect to a database via an ODBC driver or via an 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 via an Native Connector.
<Report used>: Report name
Name of report to use.

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

<Report used>.ODBCPassword = <New password>
<Report used>: Report name
Name of report to use.
<New password>: Character string (with quotes)
Password to be used to connect to the database via an ODBC driver or via Native Connector. This password must be the password defined when the connection was created.
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:
ODBCSQLCodeAllows 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.
ODBCPasswordAllows to know and modify the associated password for the user authorized to access a database via an ODBC driver or via an Native Connector.
ODBCDatabaseNameAllows 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.
ODBCConnectionNameAllows to know and modify the name of the Connection used for handle a database accessed via an ODBC driver or via an Native Connector.
ODBCUserNameAllows 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

0
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment