At 12:32 PM 1/14/2008, Dan Goldberg wrote:
I am trying to figure out how to display the expression in the column
properties of the db grid but do not know how to fill it out.
I am trying to fill out the expression tab but it does not display.
I am probably missing something simple.
Dan,
The DB Grid Expression option is intended to define a lookup expression
to fill in all values for DB Grid column drop-down menu.
A typical example would be to fill in the "CustState" column using the
lookup values defined as expression based on the "State" column in
"StateAbr" table.
To use the DB Grid Expression feature, try the following:
(R:BASE 7.6, C/S:I 7.6 and Turbo V-8 for Windows)
01. CONNECT RRBYW14
02. Database Explorer | Forms | DBGridExpressions | Design Form
03. Form Designer | DB Grid Control | Object Properties | Columns
http://www.rbase.com/rbg76/Defining_DBGrid_Expressions_01.jpg
04. Select CustState column and then right-click for Properties or
click on "Column Properties" button to customize the properties
for CustState column.
05. Column Properties (CustState)
Select the [Expression] tab and then use the following options:
Table Name: StateAbr
Expression: (State)
WHERE Clause: ORDER BY FullState
http://www.rbase.com/rbg76/Defining_DBGrid_Expressions_02.jpg
06. Click on [OK] button to save Column Properties
07. Click on [OK] button to save DB Grid Properties
08. Save the form and close the form designer
09. EDIT USING DBGridExpressions
http://www.rbase.com/rbg76/Defining_DBGrid_Expressions_03.jpg
10. While entering/updating, clicking on the "State" column will
bring up the drop-down menu for "State: using the DB Grid Column
lookup expression.
That's all there is to it!
If you need the actual form (DBGridExpressions) to understand the
use of DB Grid Expressions, send me a private e-mail.
Very Best R:egards,
Razzak.
