[RBASE-L] - Tip of the Day - Dynamically Changing Band List Properties

[A. Razzak Memon]

Thursday, April 14, 2011

Tip of the Day - Dynamically Changing Band List Properties
Product: R:BASE eXtreme 9.1 (32/64)
Update.: 3
Build..: 9.1.3.10417 or higher http://www.rupdates.com
Section: Forms
Control: Enhanced DB Grid (Band List)
Did you know that you can dynamically change the properties of
Enhanced DB Grid Band List(s), including the CAPTION and FONT.

Now you may use the following GETPROPERTY/PROPERTY commands:

-- To Obtain Band Count in Enhanced DB Grid
   GETPROPERTY ComponentID BANDS->COUNT vValue

-- To obtain Current Caption for a Given Band in Enhanced DB Grid
   GETPROPERTY ComponentID BANDS[n]->CAPTION vValue

-- To Dynamically Change Caption for a Given Band in Enhanced DB Grid
   PROPERTY ComponentID BANDS[n]->CAPTION value

-- To Dynamically Change Font Name for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_NAME value

-- To Change Font Color for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_COLOR Value

-- To Dynamically Change Font Size for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_SIZE value

-- To Dynamically Change Font Height for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_HEIGHT value

-- To Dynamically Change Font Bold Style for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_BOLD value
   Values TRUE/FALSE

-- To Dynamically Change Font Italic Style for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_ITALIC value
   Values TRUE/FALSE

-- To Dynamically Change Font Strikeout Style for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_STRIKEOUT value
   Values TRUE/FALSE

-- To Dynamically Change Font Underline Style for Band(s) in Enhanced DB Grid
   PROPERTY ComponentID BANDS->FONT_UNDERLINE value
   Values TRUE/FALSE

   -- Example 01
   -- Database: RRBYW17
   -- Form Name: RBG91_EnhancDBGrd_BandList_Properties
   -- Control: Enhanced DB Grid
   -- Related Tables: Customers, InvoiceHeader
   -- Component ID: DBGrid_Customers, DBGrid_Invoices
   -- Band List Count: 1
   -- Bit Button: [Change Band Properties]
   -- Custom EEP:
   PROPERTY DBGrid_Invoices BANDS[0]->CAPTION 'Selected Customer 
Invoice Details'
   PROPERTY DBGrid_Invoices BANDS->FONT_NAME Tahoma
   PROPERTY DBGrid_Invoices BANDS->FONT_COLOR GREEN
   PROPERTY DBGrid_Invoices BANDS->FONT_SIZE 8
   PROPERTY DBGrid_Invoices BANDS->FONT_BOLD TRUE
   RETURN

   For your viewing pleasure ....
   Before: http://www.razzak.com/tips/Enhanced_DB_Grid_BandList_Before.png
   After: http://www.razzak.com/tips/Enhanced_DB_Grid_BandList_After.png

Have fun!

Very Best R:egards,

Razzak.