 MAV direct ODBC (MAV) class and template is a set of classes and templates for quick, easy and powerful access to SQL servers using ODBC API.
Benefit of using MAV direct ODBC (MAV) class and template:
- Use of ODBC 3 opportunities has allowed to increase speeds of data exchange repeatedly.
- DRIVER-less approach of development (don't need to pay the money for SQL accelerators).
- Development remained the same - Application & Dictionary.
- Flexibility of the SQL queries creation, there is no stiff binding to the dictionary file RECORD structure.
- Getting data from the tables not described in the dictionary.
- Full-function working with the DATETIME fields (BETWEEN construction etc), NULL fields, SP (stored procedures).
- The Constructors of the SQL queries.
- Say NO to "File Already Open" error !
- Getting data and putting it in any buffers, it is not required to describe any Alias in the dictionary.
- Connection - does not require making the source of ODBC (DNS).
- Work with any SQL server for which there is corresponding ODBC driver.
- Trace the library working with the Trace utility (similar to Trace Database Driver utility from Clarion).
- Multi connections - simultaneous work with the several SQL servers.
- Support of multi connections for the same file from the dictionary.
- Support of BLOB fields.
- Support of ODBC cursors or several active cursors per connection.
- and much more!
We reviewed the 3rd party products which distribute software for Clarion + SQL, i.e. templates, libraries, classes, but all of them utilize "FILE, DRIVER" technology, and no matter how they tried to optimize the templates, it was still impossible to overcome the limitations and inherent errors of the driver. Toolkit for creation of the client-server based applications in Clarion environment.
The basic idea behind the creation of the given product was total rejection of the "FILE, DRIVER" technology during development of programs. A unique access library was written. Nothing has changed from the developer's view point, the Application and Dictionary are still present, but the product generates a totally different code (.CLW), namely there are no files but there are type groups - file prototypes.
As it was mentioned in the foreword the process of connection has become more flexible and customized. ODBC block cursors are used for data acquisition from the server instead of the non-block ones. Simple tests have shown an enormous gain in access speed:
| ! === Clarion technology |
! === MAV technology |
| SET(File)
LOOP
NEXT(File)
CASE ERRORCODE()
OF 0
OF 33
BREAK
ELSE
MESSAGE(ERROR())
BREAK
END
END
|
loc_Select MAVSelect
CODE
Loc_Select.Init(,0) ! read all
Loc_Select.BindFields(File,File)
IF loc_Select.Run()
SQLERROR
RETURN
END
LOOP
IF loc_Select.Fetch()
IF ERRORCODE() ~= 35
SQLERROR
END
BREAK
END
END
|
The tests show an increase for MSSQL server in 10 to 35 times and for Oracle server in 6 to 10 times.
Includes:
- Library version.
- Template version (full clone of the standard templates (with some extra) for easy work with the library).
 Download Trial/Demo Downloads: 1482 |
