Where: student home like: ls_home
String ls_home
Ls_home=trim (Sle_home. Text)
If not ls_home="" then
Ls_home ls_home="%" + + "%
"Dw_home. Retrieve (ls_home)
The else
MessageBox (" data is not complete, "" please type in the name of the region to query the student,")
End the if
Sle_home. SetFocus ()
Completely corresponding to the query, conditions, the retrieval results right
But conditions are not completely, fuzzy query, no results
Over checking many times, still won't do
Depressed ING ~ ~ ~ ~
CodePudding user response:
Ls_home=trim (sle_1. Text)If ls_home='or isnull (ls_home) then
Ls_home='%'
The else
Ls_home +='%'
End the if
Dw_home. Retrieve (ls_home)
CodePudding user response:
Check code is no problem, datawindow!!!!