Servizi   Carrello  Conto personale   Contattaci  
English Русский Italiano    
Ricerca Prodotti
 

Scelgi Valuta
MAV Direct ODBC - 1.01   Rating 
 di Ingasoftplus  
 Overview 
 Pricing&Licensing 
 Compatibility 
 Publisher Details 
 Screenshot Gallery 
 Reviews 
 Novità 
Product Overview: MAV - MAV Direct ODBC - 1.01
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:

  1. Library version.
  2. Template version (full clone of the standard templates (with some extra) for easy work with the library).


 Scarica Trial/Demo  Scaricato: 1482
Designed by mixer ®, 2006

Sign up for PayPal and start accepting credit card payments instantly.
© Copyright 2006-18 MotleySoft.com, a service of MediaPro (p.iva 09509960010). All rights reserved
All prices listed are subject to change without notice. Not responsible for typographical errors.
   Politica sulla Privacy