|
|
|
|
|
- Overview
- Importing the structure of files
- The import steps
- Take into account changes in the Sybase database
- Programming
- 1. Establishing the connection
- 2. Running queries
- 3. Retrieving the result
- 4. Closing the connection
- Optimization
SAP ASE Native Connector (Sybase): Programming with HFSQL functions
Disponible solo con este tipo de conexión
To use a Sybase database with Native Connector, the structure of Sybase tables must be imported into the WINDEV or WEBDEV analysis. Differences from SQL programming: To manipulate Sybase data, queries are not mandatory. In fact, you can directly use HFSQL functions to read your data, carry out searches, filters, etc. However, you need to import the Sybase file structure into the WINDEV or WEBDEV analysis. Importing the structure of files The import steps To perform this import: - Launch the data model editor: click on
among the quick access buttons. - On the "Análisis" tab, in the "Creación" group, expand "Importar" and select "Import file/table descriptions...".
- The wizard starts. A connection to the Sybase database is automatically established and it is associated with the files imported into the analysis. This connection will be used to handle the Sybase data file programmatically.
In the different steps of the wizard, choose the following options: - Database type: Sybase.
- Connection features: Data server, User and password, Database.
- The application will access the data in the current format.
- When the connection is established, all you have to do is select the tables that will be imported into the WINDEV or WEBDEV analysis. These tables can be handled through programming with the HFSQL functions of WLanguage. These tables will be displayed in blue in the data model editor.
Take into account changes in the Sybase database To take account of changes to tables imported into the data model editor, in the "Análisis" pane, in the "Análisis" group, pull down "Sincronización " and select "Update analysis from external databases". A wizard starts, allowing you to: - analyze the differences for the imported tables.
- analyze the differences for all the Sybase tables.
1. Establishing the connection To establish the connection to the Sybase database, use HOpenConnection and specify the name of the connection to open. The connection name was defined when importing the structure of files into the analysis. To modify some parameters of this connection (username or password for example), call HConnect. Remark: If you attempt to read the file directly (function HReadFirst, ...), the connection associated with the file description in the analysis will be automatically opened. 2. Running queries - HExecuteQuery: is used to run a preset query with the query editor.
- HExecuteSQLQuery: is used to run a query by specifying the SQL code of the query and the name that will be assigned to this SQL code.
HExecuteQuery(CUSTOMER_84, "SybaseDatabase", hQueryWithoutCorrection)
HExecuteSQLQuery(CustomerQry, "SybaseDatabase", hQueryWithoutCorrection, ...
"SELECT NAME FROM CUSTOMER")
3. Retrieving the result Note: The hLockWrite and hLockRead constants are ignored.. Indeed, the read and/or write locks are not supported by the Native Connector. 4. Closing the connection HCloseConnection is used to close the connection to the database once all the necessary queries have been run. Optimization - Table control based on a data file is optimized. You can sort the contents of a Table control by clicking on one of its columns.
- To avoid re-running the same query several times when browsing its result, we advise you to use the hNoRefresh constant (if the data is modified by a single computer for example).
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|