>>>>
Here's one for the R> Team... While in a form, I want the user to be
able to pick the sort order of items that appear in a Combo Box. In an effort to
achieve this, I created two radio buttons which will load a variable called SORD
with the column name LNAME or EMPNO I then use the following statement in
the Combo Box Properties WHERE CLAUSE dialog box: ORDER BY &SORD
WHERE COMPANY = .VC This where clause will not work in the form, but does
work at the R> Ideas greatfully accepted on this one! -
Rob,
01. The Glorious R:BASE 2000 (ver 6.5++) for Windows
includes a sample database (CMS) and the application
to demonstrate the dynamic WHERE .. ORDER BY ...
functionality in Combo Box and/or Pop-Up Menu.
C:\RBTI\RBWIN65\SAMPLES\CMS
Database: CMS
Form: MainMenu
EEP: CMS.EEP
RUN CMS.DAT will demonstrate the functionality.
02. In your case, make sure to pre-define all related
variables, such as, VC and SORD.
03. Make sure to use RECALC VARIABLES in EEP.
RECALC VARIABLES forces recalculation of all expressions
defined for the current table and all located variables
for that table. Expressions and variables for other tables
are not affected.
RECALC VARIABLES is typically used in a field level EEP.
Enjoy and make sure to have fun!
Very Best Regards,
Razzak.
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
