| | | | |
| |
|  |  | |
|
S/QBF Copyright (c) 1999 Sprezzatura Ltd. All Rights Reserved. Revelation, Advanced Revelation and OpenInsight are trademarks of Revelation Technologies Inc. All trademarks used in this document are used to the benefit of and are the property of their respective holders. Thank you for purchasing the Sprezzatura QBF ( S/QBF ) replacement component. We are sure that you will be pleased with the additional functionality it makes possible for you and your clients. Over the past few months we have seen an influx of users who are more familiar with the old Advanced Revelation command syntax and have been chagrined by the lack of ability in OpenInsight to do a simple range search, or to order reports. This software was designed to address those issues. Whilst setting about improving on OpenInsight's QBF we decided to also improve on AREV's Window Query tool. So this release contains the following features :-
Simply run Setup.exe from the medium you have installed the S/QBF package to. Using S/QBF is extremely simple - for each of the standard QBF events on an OpenInsight form there is a corresponding S/QBF function call that replaces them, so all you have to do is call the SQBF() function with the appropriate parameter in your event scripts. The general syntax of the SQBF() function is bSuccess = SQBF( Window, Method, Param ) where:
Returns TRUE$ for success, FALSE$ otherwise. SQBF_EXAMPLE The QBF events on the SQBF_EXAMPLE form included in the installation shows you how this is done. Note the use of Event Scripts with a RETURN 0 as opposed to using QuickEvents. This is because S/QBF uses none of the resources used by the standard OI QBF and the two are incompatible. If you wish to use S/QBF exclusively throughout your application then you may wish to use 'global' events instead. In this case please refer to the OpenInsight Event Designer documentation ( or a previous version of the Sprezzatura Electronic Newsletter where this was covered :-)
The following additional functionality is also available: Refining Lists If you initialize ( QBFINIT ) and execute ( QBFRUN ) an S/QBF query, and then repeat this again without performing a QBFCLOSE inbetween, the results of the first query are used as the basis for the second one, thereby refining it. If you wish to avoid this behaviour you must perform a QBFCLOSE event before initializing subsequent queries. Saving Query Results Once you have executed a query you may save the resulting list of keys by using the QBFSAVELIST method. eg. ListName = "MYLIST" Call SQBF( @Window, "QBFSAVELIST", ListName ) The list of keys is saved to the SYSLISTS table in the same manner a normal saved list, and may be used in other programs by Activate_Save_Select() for example. Loading Saved Lists If you have a list of keys saved and you want to utilise them as thought they were the result of an S/QBF query then you may use the QBFLOADLIST method to do so. eg. ListName = "MYLIST" Call SQBF( @Window, "QBFLOADLIST", ListName ) This will load the keys in the saved list "MYLIST" into the form for further processing, as though you had executed the QBFINIT and QBFRUN events to construct them. Loading the Previous Query S/QBF always stores the last-run query statement so you can use it again if you wish. To retrive and execute it use the QBFLOADLIST method eg. Call SQBF( @Window, "QBFLOADQUERY", "" ) You will then see the Query view window with the last statement so you can modify it before execution if you so wish. ARev QBF Syntax compatibility S/QBF duplicates AREV's functionality and uses the same operators so the following can be used:
The installation routine installs the following OpenInsight components in your SYSPROG account. S/QBF Core Components
S/QBF Example Components
| | | | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Copyright © 2005 The Sprezzatura Group. All rights reserved. | |
