//////////////////////////////////////// //////////////////////////////////////// //////////////////////////////////////// Function Name wf_additem (dropdownlistbox fo_obj, string fs_ SQL) // parameter: fo_obj is the drop-down list box, And fs_ SQL is the SQL statement // return value: NONE // function: use the SQL statement specified by the parameter to add data to the specified drop-down list box ////////////////////////// //////////////////////////////////////// //////////////////////////////////////// //////// string ls_item declare item_cur Dynamic Cursor for sqlsa; // define the Dynamic Cursor prepare sqlsa from: fs_ SQL using sqlca; open dynamic item_cur; // open the Dynamic Cursor fetch item_cur into: ls_item; // obtain the data fo_obj.setredraw (false) // disable the do while sqlca refresh in the drop-down list box. sqlcode = 0 fo_obj.additem (ls_item) // Add the project fetch item_cur into: ls_item; loop fo_obj.setredraw (true) to the drop-down list box to close item_cur; // close the Dynamic Cursor