DtvLong dal_wdh_upd_lis ()

Executes a data query for search terms in the fields of a mask and enters all records containing the search terms found into the record buffer of the mask .

Input Parameters Significance
none -

Output Parameters Significance
none -

Return Code Significance
0 no error
1 error at pre_action-trigger for query mode
2 mandatory-field not filled
4 "Incorrect query value(s)"
-1 not all found records loaded,
In this situation, the return code -1 is only returned for masks without record scan (no database sorting set in the maske-field relation). For masks with record scan (database sorting set for at least one field) the function returns code 0.

Can be invoked as on_select-userexit in widget menus or as on_event-userexit in widget state or in query mode of mask edit state of a mask.

If the query delivers more records than allowed by the maximum record length of the mask , DataView will cancel loading and output an error message in the message window. If the search was started with at least one database sort criterion set, the remaining records can be fetched via record-scan. This, however, will result in a low performance because of the database sorting.

If you expect a query result with more records than defined in the maximum record length or you cannot predict the record length of the query result, you had better use the function dal_wdh_upd_sng. This function reads only one record at a time from the data base and writes it into the mask. After evaluating or editing this record you can load the next one into the mask, invoking dal_wdh_upd_sng again. Especially when programming with virtual widgets you should apply this function to prevent overflows of local storage.