
The code is as follows:
String ls_select, ls_where ls_doctordept;
If sle_1. Text="" or sle_2. Text=" "then
Messagebox (" error ", "please input data!" )
The else
Dw_1. Settransobject (sqlca)
Ls_select="SELECT * FROM ORDERS"
Ls_where="where id1='" + sle_1. Text +"' and id2="+ sle_2. Text +"
"Dw_1. Setsqlselect (ls_select + ls_where)
Dw_1. Retrieve ()
End the if