Adding record selections

Euroboy

Active Member
Can anyone tell me how I can add runtime record selection to a file?

Thanks
 
I need it for UBE right now, but answer to both would be nice for future use no doubt
 
For UBE:
On “Initialize Section” set system function (General) “Set Selection Append Flag”. After that use “Set User Selection”. “Item1” is business view column and “Item2” is usually processing option.
For APPL:
Add business view fields for selection into header and set filter property to “=”. Populate those fields in “Post Dialog Is Initialize” event with constant or processing option value. You can hide fields to suppress changing your data selection.

Regards,
Bojan.
 
Hi Euroboy,
You have forgotten to describe your system configuration information.
Which release of OneWorld do you working on?
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Euroboy,
FDA application:
================
* ClearQBEColumn
* ClearSelection
* SetLowerLimit
* SetQBEColumnCompareStyle
* SetSelection
* SetSelectionsAppendFlag
System Functions (all in Grid category) exist for interactive application. (I'm not sure that do they exist already in prior B7331 version).
You can use them to manage your run-time selection in interactive applications.
Good luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
An other method for APPLs:
==========================
* You can manage the value of QBE fields (assigning value to them) in the Event Rule
I know, it isn't always a possible solution.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Third method for APPLs:
=======================
1.) Put your Business View Column(s) onto the Form.
2.) Set the Filter options on the Properties sheet.
3.) Turn off the Visible flag (also on the Properties sheet) making it hidden.
4.) Manipulate the value of this controls in your Event Rules as you need. (You can use wild-card if you have set it up on the Filter properties.) The appropriate events are Dialog is Initialized form event and the Button Clicked event of the Find form exit.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Euroboy,
I almost forget an other solution for APPLs.
This method could be useful when your selection criteria is more complicated and you can not make it with field based selection only.
=======
Evaluate your selection criteria coding event rules based on the BC values of the currently fetched record in the "Grid Record Is Fetched" event. If you want to omit the current record then issue a "SuppressGridLine" system function (also Grid category)
=======
Hope, could help (for the future :)
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Back
Top