%HI_RefreshData( INT in refId [, TEXT in whereStr [, TEXT in orderByStr [, in par1[, in par2[, ...]]]]] ) BOOL %HI_RefreshDataSync( INT in refId [, TEXT in whereStr [, TEXT in orderByStr [, in par1[, in par2[, ...]]]]] ) |
refId | Reference to graphic object
(reference variable). |
whereStr | SQL condition WHERE for selection limit of displayed data (for Browser type only). |
orderByStr | SQL command ORDER for selection order control (sorting) (for Browser type only) |
par1, par2, ... | List of constants or local variables that will be used instead of the parameters of parameterized SQL condition. |
rules for whereStr and orderByStr:
Entered valid | Empty or entered but invalid | |
whereStr | change of condition | The last entered condition is valid (if it has not been entered, there is an empty string). |
orderByStr | change of sorting | The last entered sorting is valid (if it has not been entered, there is an empty string). |
%HI_RefreshData(_browser) ; updating (without changes in condition, sorting or parameters) %HI_RefreshData(_browser, "ID=21") ; changing the condition and updating %HI_RefreshData(_browser, "ID=21", "ID") ; changing the condition, sorting and updating |
INT _cnt ; the local variable for the parameterized condition TEXT _name ; the local variable for the parameterized condition TEXT _INVALID = 1/0 ; auxiliary invalid constant of text type _cnt := 1 _name := "%SELF%" ; 1. change of condition (parameterized), sorting, parameters and updating %HI_RefreshData(_browser, "CNT=#PAR# AND NAME LIKE #PAR#", "NAME", _cnt, _name) _cnt := 2 _name := "%ODBC%" ; 2. just the change of parameters (recycling the SQL expression) and updating %HI_RefreshData(_browser, "CNT=#PAR# AND NAME LIKE #PAR#", "NAME", _cnt, _name) ; %HI_RefreshData(_browser, _INVALID, _INVALID, _cnt, _name) ; equivalent alternative to the writing by line above (if the condition has not been changed from the point 1) ; 3. without changes (recycling the SQL expression) and updating %HI_RefreshData(_browser, "CNT=#PAR# AND NAME LIKE #PAR#", "NAME", _cnt, _name) %HI_RefreshData(_browser) ; equivalent alternative to the writing by line above (it the condition, sorting and parameters have not been changed from point 2) |