OZLib is a control and class library for Fivewin and Fivewin for [x]Harbour that increase considerably the power of Fivewin itself

OZ Software during his stage as the official distributor of all Fivetech products did develop a lot of controls and classes that we did include them on the Fivewin library without loosing our copyright. Actually those controls are still on the library even when OZ Software is not anymore the official distributor, but obviously OZS has stopped from enhancing and supporting as part of Fivewin or FWH. All those controls, really enhanced, and some new ones are the core of the new OZLib library.

OZ Software offers support and free upgrades of OZLib during a year from the date of purchase.

Is our intention to improve the library including new controls and classes. This improvements will not requiere the payment of any money to all the already registered owners within the first year of acquisition.

Controls:

• xBrowse: Grid Control for Fivewin and FWH to display any kind of data, like database files, arrays, etcetera. xBrowse has the same look that the standard grid contols used by Microsoft on their latest operating system releases. This are some of their superior features:
  • Column object completely and individually configurable: color, font, bitmaps, alignment, height, width
  • Multiline on header, data and footer
  • Bitmpas on header, data and footer (besides grid body)
  • Alignment for text and bitmaps on header, data and footer
  • Color assignment by codeblocks at the browse level, or column level to change the color based on run-time criteria
  • Column and row resizing with the mouse
  • Column swapping the same way that Microsoft Outlook
  • Possibility to cancel scroll bars
  • Ready to be used with any kind of data: RDDs, Arrays, oDbf (it can be even adjusted to be used with any special RDD provider)
  • Possibility to show a record selector on the left margin of the browse
  • Real state persistence: Saves and restores actual configuration of columns, their order, visibility and size on a single line of text
  • Columns freeze
  • Use of diferent types of fonts for headers, footers and data. Any column can have its own fonts.
  • Multiple style for vertical and horizontal lines: No line, black line, dark gray, light gray, raised, inset and the same as the foreground text color
  • The vertical lines can reach till the end of the browse or it can stop at the end of the latest visible data line
  • Columns auto-sort (only for arrays)
  • Column hidding configurable by the user
  • Incremental search
  • Spreadsheet style edition
  • Multiples marque styles:
    • No marquee
    • Dotted cell
    • Single line cell
    • Highlite cell
    • Highlite row
    • Highlite row and raised cell
    • Highlite row and MULTISELECT
  • Support of column edition with the following formats:
    • No edition
    • GET edition
    • Listbox edition
    • "..." button edition
    • GET & listbox edition
    • ET & "..." button edition
  • Different event trapping for any column:
    • Header lclick and rclick
    • Footer lclick and rclick
    • Data lclick and rclick
  • Mousewheel support (only in FWH)

• Outlook bar: Control for Fivewin y FWH wich is a vertical button bar with the same style as Microsoft Outlook. This control is based on a work from Jose Lalin that he freely donate it to the Fivewin comunity that you may find at www.fivewin.info, anyhow actually our Outlook bar control it does not seem too much to the control created by Jose Lalín. In difference with the basic control of Jose Lalín our control has the following features:
  • Drag & Drop
  • State persistence: You can save and restore his complete state
  • Scroll buttons when the bitmap buttons do not fit on the bar
  • Possibility to add groups and buttons on run-time
  • Swap of bitmap buttons position even dragin them to another bar
  • Automatic adjustment of text literals of buttons in more than one line when they not fit on the actual bar width

• DateTime Picker:Control for FWH based on the DateTime Picker control from the Microsoft Common controls to edit date type variables. Includes the possibility to show a small windows showing a calendar to make the date selection easier.

Classes:

• ODBC Direct: Classes for Fivewin and FWH to manage any external database like any SQL engine, or any other database system wich has an ODBC driver. With ODBC Direct the access to any SQL engine becomes a very easy job. The SQL acknowledge to start working with ODBC Direct is really low, you only need to perform a SELECT and afterwards ODBC Direct will handle all the typical database operations like additions, deletes, editions, etcetera.

  Actually and thanks to the existence of some great and free SQL engines like FireBird (Interbase) or MySQL there is no reason to continue using the old and problematic DBF format.

  ODBC Direct uses as a buffer for all his queries a temporal DBF files, which gives you the possibility to continue using the same browses that you have use until now, so the changes to your actual applications will become minimal. On those temporal database file you may do whatever operation you want like filters, indexes, seeks, or any other typical operation that can be done with DBF files.

• Report Generator: Classes TReport, TGroup, y TRLine for Fivewin y FWH to generate reports. This classes were on Fivewin from long time ago, but they are a exclusive work of OZ Software, and our intention is to enhance the report generator including new functionalities and improving his actual features.

• Class TChart: Aid class for ChartFX for Fivewin. This class make the graph generation with ChartFX a very easy job. The class does all the job for you, creates the window, puts the menu options necessary and modifies the button bar with your prefered configuration. Includes the ability to print the graph to any available printer on your system.

  His use is really simple, here is a small sample:
  
  

  oChart := TChart():New("Mi Gráfico")
  
  oChart:cUpTitle := "Mi graph at day " + Ctod(Date())
  oChart:cDownTitle := "From Center 1 to 10"
  oChart:cLeftTitle := "Partners"
  oChart:cRightTitle := "Men/Women"
  
  oChart:ReadTemplate(oApp:cGraphFile) // restores the last confituration made by the user
  
  oChart:SetSeries(2, 10))
  
  FOR nFor := 1 TO 10
  
  oChart:Legend(nFor,aLegend[nFor])
  
  NEXT
  
  FOR nFor := 1 TO 10
  
  oChart:SetValue(1, nFor, aHom[nFor])
  oChart:SetValue(2, nFor, aMuj[nFor])
  
  NEXT
  
  oChart:Activate()

• Class TOZdbf: Class to manage via OOP any DBF file for Fivewin and FWH. This class is intended to be used to manage any DBF file via object oriented programming, instead of the old Alias method. Besides it includes some powerfull methods and datas that simplify considerably the work with DBF files. The most important features of this class are:
  
  
  • Process management. Any opened file can be part of a process. When the process is closed all the files of that process are closed automatically.
  • No need to use the command USE any more, for example:
    
    oProc := TProcess():New("Sales")
    oDbf1 := oProc:Add("c:\dir\myfile1.dbf")
    oDbf2 := oProc:Add("c:\dir\myfile2.dbf")
    oDbf1:lShared := .t.
    oDbf1:cRDD := "DBFCDX"
    oDbf2:lShared := .t.
    if !oProc:Open()
    
    oProc:End()
    return nil
    
    endif
    oDbf1:OrdSetFocus("name")
    .......
    oProc:End()
    
    
  • Set of temporal variables to be used for edition with the same name than the field but with the text 'Var' in front.
  • Automatic or semi-automatic lock mechanism
  • Recall of deleted records on APPEND operations
  • Pack & Zap over shared files
  • Methods to save and restore actual database state (recno, filters, orders, scopes, etcetera)
  • Methods to sort the table on any field (ascending or descending). It creates the temporal index file and deletes it when the file is closed
  • Method to save to an array all or part of the table data
  • Method to add virtual fields to the table

Version 3.0 now available

		OzLib 3.0 order form
		OzLib upgrade order form
		Download OzLib demo Version: 3.0 Size: 1.01 MB