PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • What is a query performed on a connection?
  • Properties used to manage reports based on data files accessed via an ODBC driver or via a Native Access
  • 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 via a Native Access.

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 a Native Access. This query was defined during the report creation.
  • Modify the SQL code of the "query performed on a connection" (data source of report).
Note: 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 Name>..ODBCSQLCode
<Result>: Character string
Text of the SQL query that must be run on the database accessed via a specific ODBC driver or via a Native Access. This query must be a Select query (SELECT).
<Report Name>: Character string (with or without quotes)
Name of report to use.

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

<Report Name>..ODBCSQLCode = <New SQL Code>
<Report Name>: Character string (with or without quotes)
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 used to manage reports based on data files accessed via an ODBC driver or via a Native Access

The following properties are used to manage reports based on fdata iles accessed via an ODBC driver or via a Native Access:
ODBCSQLCodeUsed to find out and modify the SQL code of the query performed on a database accessed via an ODBC driver or via a Native Access.
ODBCPasswordUsed to find out and modify the password associated with the user allowed to access a database via an ODBC driver or via a Native Access.
ODBCDatabaseNameUsed to find out and modify the name of the database used by the query performed on a database accessed via an ODBC driver or via a Native Access.
ODBCConnectionNameUsed to find out and modify the name of the connection used to access a database via an ODBC driver or via a Native Access.
ODBCUserNameUsed to find out and modify the name of the user allowed to access a database via an ODBC driver or via a Native Access.

Limit

..ODBCSQLCode 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