QBF, How to "Select All"? (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 26 JAN 2000 02:24:31AM Kendal Hulbert wrote:

OpenInsight Specific

I'm a VB programmer originally, where the '*' is used to represent a "Select all" command. To access the entire database using the QBF feature of OpenInSight, what special character, if any, is used?

Either respond here or I can be e-mailed at [email protected].

Thanks.

At 26 JAN 2000 04:05AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

There is no special character. A kludgy hack would be to enter ]'' in the key prompt, thus returning all rows with a primary id (hence all rows).

VB is set oriented, OI is transaction oriented. You will probably find better results from coding your own query to activate a latent select to the beginning of a btree index and use your own code to work through it. (See docs on RLIST).

The Sprezzatura Group

World Leaders in all things RevSoft

At 27 JAN 2000 03:45PM Don Miller - C3 Inc. wrote:

Sprzz is on target with the ] at the key prompt. There is another little "Feature": If you have any radio-buttons in your form, you can't get the "All" unless they contain the "Default" radio-button value. You can't clear the radio-button!!

Also, if you're going to modify records in QBF, not that any script in the form hooked ahead of the READ event won't be executed. For example, in a number of forms we save the contents of the original record as read from disk in @WINDOW,"@ORIG". We use this to compare against entered values in order to do incremental updates in associated tables. Personally, I'm not fond of QBF except for browsing and lookups.

Don Miller

C3 Inc.

At 27 JAN 2000 04:19PM Steve C. wrote:

If you do have Radio buttons you can "null" them out in the

following manner so that you can perform a QBF.

Note that I have 3 radio buttons named GENDER,LONGEVITY_HAZARD,

and EXEMPT_CHECK.

In the FORM'S Window QBFINIT event script:

DECLARE SUBROUTINE FORWARD_EVENT

.GENDER-]VALUE='

.LONGEVITY_HAZARD-]VALUE='

.EXEMPT_CHECK-]CHECK='

FORWARD_EVENT()

.GENDER-]VALUE='

.LONGEVITY_HAZARD-]VALUE='

.EXEMPT_CHECK-]CHECK='

RETURN 0

In the FORM'S Window QBFRUN event script:

DECLARE SUBROUTINE FORWARD_EVENT

DECLARE FUNCTION REPOSITORY

.GENDER-]VALUE='

.LONGEVITY_HAZARD-]VALUE='

.EXEMPT_CHECK-]CHECK='

Forward_Event()

RETURN 0

At 27 JAN 2000 05:34PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

Hey why do you think we developed SQBF? See our "What's New" for recent fixes….

The Sprezzatura Group

World Leaders in all things RevSoft

At 03 FEB 2000 05:01AM Kendal Hulbert wrote:

Thanks, I will rather do my own coding, as suggested.

Thanks again for the input.

View this thread on the forum...