At 12:14 PM 5/1/2010, Mike Epstein wrote:
Is it possible to refresh the order of items entered into a
scrolling region? In other words say you were entering random
part numbers into a forms scrolling region could you have a
button with a property command that would refresh the order?
Mike,
If you started the form with ORDER BY clause, such as:
EDIT USING formname WHERE clause ... ORDER BY clause ...
You could use the following PROPERTY command to refresh the
entire data set on demand while still looking at the form.
Here's how:
00. Start R:BASE 7.6, Turbo V-8, or R:BASE eXtreme 9.0 (32/64)
01. While in form designer, place a "Speed Button" control.
Speed Button control does not have any focus nor tab stop
to hinder data entry. Perfect control for on-click actions.
02. Use the following code as "Custom EEP" for Speed Button:
-- Refresh Scrolling Region Data
PROPERTY TABLE <Scrolling_Region_Table_Name> 'CLOSE'
PROPERTY TABLE <Scrolling_Region_Table_Name> 'OPEN'
RETURN
03. Save the form.
04. At the R> Prompt:
EDIT USING formname WHERE clause ... ORDER BY clause ...
or
Using the Database Explorer, double-click on the form and
use the following code for WHERE Clause ...
WHERE clause ... ORDER BY clause ...
04. Now make all inserts, updates, or deletions accordingly
and then click on the [Speed Button].
Notice the instant refresh with correct ORDER ...
Wow !!!!
That's all there is to it!
If you need a sample form to demonstrate the use of such technique,
feel free to contact me privately on my private e-mail address.
Yes, you do have my private e-mail address <g>.
Good Luck and Very Best R:egards,
Razzak.
