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 username 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 through programming with the WLanguage properties.
ODBCUserName is used to:
- Identify the username used to connect to a database via an ODBC driver or a Native Connector. This name must be specified when printing a report based on a "query performed on a connection".
- Specify the username used to connect to a database via an ODBC driver or a Native Connector. This name 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.
// -- Opening code of the report
RPT_Report1.ODBCConnectionName = "MyConnection"
RPT_Report1.ODBCSQLCode = "Select * FROM Products"
RPT_Report1.ODBCUserName = "MOORE"
RPT_Report1.ODBCPassword = "PSW"
Syntax
Identifying the username used to connect to a database via an ODBC driver or a Native Connector Hide the details
<Result> = <Report used>.ODBCUserName
<Result>: Character string
Username defined in the report, used 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 username used to connect to a database via an ODBC driver or a Native Connector Hide the details
<Report used>.ODBCUserName = <New name>
<Report used>: Report name
Name of the report to be used.
<New name>: Character string
Username used to connect to a database via an ODBC driver or a Native Connector. This name must correspond to the username defined when the connection was created in the administrator of the ODBC driver or Native Connector.
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:
| |
| ODBCConnectionName | Used to identify and change the name of the connection used to handle a database accessed via an ODBC driver or a Native Connector. |
| ODBCDatabaseName | Used 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. |
| ODBCPassword | Used to identify and change the password associated with the user allowed to access a database via an ODBC driver or a Native Connector. |
| ODBCSQLCode | Used to identify and change the SQL code of the query executed on a database accessed via an ODBC driver or a Native Connector. |
| ODBCUserName | Used to identify and change the name of the user allowed to access a database via an ODBC driver or a Native Connector. |
Limit
The ODBCUserName property applies only to the reports based on a "query performed on a connection".