VO2Jet Specifications:

VO2Jet is a Class Library for Visual Objects (VO) that gives VO developers an efficient and easy to use interface to the Microsoft Jet Engine, the database engine behind Microsoft Access, Microsoft Visual Basic and Microsoft Visual C . The Jet Engine is used by many commercial products on the market.

The Class library consists of a set of classes that talk directly to the Microsoft Jet engine using the DAO programming layer.

It also has a set of higher level DbServer compatible classes that allows VO developers to use the Jet Engine in combination with the VO DataWindow and Databrowser classes (but also with 3rd party tools such as bBrowser and GridPro)

VO2Jet comes with its own Editor subsystem that integrates into the VO Integrated Development Environment. This subsystem generates both the necessary binary entities to use Jet databases with the auto-layout function in the Window Editor, and also generates source code for the Jet database classes.

The source code generation is template based, so highly configurable. (For creating and maintaining databases we recommend other tools such as Microsoft Access) The editor can be switched to run in Jet 3.5 mode (Access '97) or Jet 4.0 mode (Access 2000).

VO2Jet comes with full source code to the class library and a number of samples, and with documentation in the form of a Windows Online Help file.

VO2Jet is invaluable for Visual Objects developers that have to interface to applications written in Microsoft Access, Microsoft Visual Basic of Microsoft Visual C . VO2Jet can also be of use to those developers that are looking for an powerful and easy to use alternative for the DBF databases. The Microsoft Jet Engine has a number of powerful features such as referential integrity and transaction support.

An example of some Vo2Jet code to open a table on a Window:

GLOBAL goEng AS DaoDbEngine
GLOBAL goDb AS DaoDatabase

METHOD Start() CLASS App
    LOCAL oWindow 	AS DataWindow
    LOCAL oServer 	AS DaoQuery
    LOCAL oShellWindow  AS ShellWindow
    LOCAL oError
    LOCAL cbErr 		AS CODEBLOCK
    cbErr := ErrorBlock({|oErr|_Break(oErr)})
    BEGIN SEQUENCE
        goEng 	:= DaoDbEngine{}
        goDb 	:= goEng:OpenDatabase("C:\Vo2Jet28\NorthWind.Mdb", ;
            NIL,NIL,NIL)
        DaoDateTimeAsDate(TRUE)
        SetCentury(TRUE)
        oShell     := ShellWindow{SELF}
        oShell:Show()
        oServer	   := DaoQuery{"qryOrders", dbOpenDynaSet, dbSeeChanges, oDb}
        oWindow    := DataWindow{oShell}
        oWindow:Use(oServer)
        oWindow:ViewTable()
        oWindow:Show(SHOWCENTERED)
        SELF:Exec()
        goDb:Close()
    RECOVER USING oerror
        Eval(cbErr, oError)
    END
    ErrorBlock(cbErr)