February 24, 2004
From the Edge: Understanding Form System Variables Section: Forms Chapter: Running R:BASE Your Way! Platform: R:BASE 7.1 for Windows Build: 7.1.71.30227 and higher
R:BASE 7.1 introduces the following RBTI System Variables used in Forms:
� RBTI_DBGRID_COLUMN � RBTI_DIRTY_FLAG � RBTI_FORM_ALIAS � RBTI_FORM_COLNAME � RBTI_FORM_COLVALUE � RBTI_FORM_DIRTYVAR � RBTI_FORM_FORMNAME � RBTI_FORM_TBLNAME � RBTI_FORM_VARNAME � RBTI_FORM_VARVALUE
RBTI_DBGRID_COLUMN This variable holds the name of focused Column on DB Grid.
RBTI_DIRTY_FLAG Returns 1 if any DB Control value(s) in form were changed or 0 if nothing was changed.
RBTI_FORM_ALIAS This variable holds the name of focused form, if used AS alias.
RBTI_FORM_COLNAME This variable holds the name of focused column DB Control on form.
RBTI_FORM_COLVALUE This variable holds the value of focused column DB Control on form.
RBTI_FORM_DIRTYVAR Returns 1 if any Variable Control value(s) in form were changed or 0 if nothing was changed.
RBTI_FORM_FORMNAME This variable holds the name of the current form. Particularly useful when using the form-in-a-form technique and multiple forms are running at the same time.
RBTI_FORM_TBLNAME This variable holds the name of the current table in a form. This is especially useful when used within a multi-table form.
RBTI_FORM_VARNAME This variable holds the name of focused Variable Control on form.
RBTI_FORM_VARVALUE This variable holds the value of focused Variable Control on form.
Tips and Techniques:
If you have variables controls on a form in EDIT mode and the value of the variable control is changed - then RBTI_FORM_DIRTYVAR will change. You can then use this to take appropriate action.
In form EDIT mode, RBTI_DIRTY_FLAG will only change if a DB control is changed that affects the displayed data set. In ENTER mode RBTI_DIRTY_FLAG is always set to 1. In EDIT mode this allows you to easily cater for a form with a mix of DB controls and variable controls - by using RBTI_FORM_DIRTYVAR you can trap in an EEP the situation where the user has only made a change to a variable control and not to any DB controls. (In this situation RBTI_DIRTY_FLAG will be 0 but RBTI_FORM_DIRTYVAR will be 1.)
For a complete PDF version of this technical document, examples and syntax, please visit:
From The Edge: http://www.razzak.com/fte (Powered by R:PHP)
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
