|
|
|
|
|
|
|
|
|
|
- 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
ODBCConnectionName (Property) In french: ODBCNomConnexion
  Available only with these kinds of connection
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 creating a connection, 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. The ODBCConnectionName property is used to: - Find out the name of the ODBC connection used when printing a report based on a "query performed on a connection".
- Specify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
Remark: This property must be used in the report opening code.
ETAT_Etat1.ODBCNomConnexion = "MaConnexion"
ETAT_Etat1.ODBCCodeSQL = "Select * from Produits"
ETAT_Etat1.ODBCNomUtilisateur = "DUPUIS"
ETAT_Etat1.ODBCMotDePasse = "PSW"
Syntax
Identifying the name of the connection used when printing a report based on a "query performed on a connection" Hide the details
<Result> = <Report used>.ODBCConnectionName
<Result>: Character string Name of connection used when printing a report based on a query performed on a connection. <Report used>: Report name Name of the report to be used.
Specifying the name of the connection to use when printing a report based on a "query performed on a connection" Hide the details
<Report used>.ODBCConnectionName = <Connection to use>
<Report used>: Report name Name of the report to be used. <Connection to use>: Character string Name of the connection used to perform the base query of the report via the ODBC driver or a Native Connector. This connection name must be defined in the administrator of the driver or Native Connector used on the current computer. 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 ODBCConnectionName property applies only to the reports based on a "query performed on a connection".
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|