String s
If sle_1. Text="' then
Messagebox (" prompt ", "please enter to find content")
The else
S=sle_1. The content of the text//query box input assigned to s
Dw_1. Setfilter (" QJMC like '% %' "+ s +" ")
Dw_1. Setfocus ()//to focus

Dw_1. Settransobject (sqlca)//connection to your database
Dw_1. Retrieve ()
End the if
This is my query code, why some do not check record, please expert advice, such as urgent

CodePudding user response:

See if you have space, appropriate to add the trim () function to don't need space

CodePudding user response:

Dw_1. Setfilter (" QJMC like '% %' "+ s +" ")
Instead of
Dw_1. Setfilter (" posw (QJMC, '" + s + ") & gt; 0 ")

CodePudding user response:

Both methods I tried, I can't

CodePudding user response:

Do not add Setfilter function, what you said is no records can check out?
In addition, the example
Sle_1. Text value? Do not check the record of what is the content of the QJMC?

CodePudding user response:

I have QJMC database records of this field: scales, digital indication, according to the optometry machine, etc., but can only investigate the optometry machine, I do not check data scales,
QJMC=trim (" % "+ sle_1. Text +" % ")
Dw_1. Retrieve (QJMC)
It's also used, no, I want to achieve by the name lookup

CodePudding user response:

Why want to use filter, under construction in dw, add a retrieval conditions where QJMC like: as_name
Then, ls_name='%' + sle_1. Text + '%'
In dw_1. Retrieve (ls_name) not to go,

CodePudding user response:

Why want to use filter, under construction in dw, add a retrieval conditions where QJMC like: as_name
Then, ls_name='%' + sle_1. Text + '%'
In dw_1. Retrieve (ls_name) not to go,


The earliest did, no,
I have QJMC database records of this field: scales, digital indication, according to the optometry machine, etc., but can only investigate the optometry machine, I do not check data scales,

CodePudding user response:

There's a better way?

CodePudding user response:

What database

CodePudding user response:

SQL 2000

CodePudding user response:

String s
If sle_1. Text="' then
Messagebox (" prompt ", "please enter to find content")
The else
S=sle_1. The content of the text//query box input assigned to s
Dw_1. Setfilter (" QJMC like '% %' "+ s +" ")

dw_1. Filter ()
Dw_1. Setfocus ()//to focus

Dw_1. Settransobject (sqlca)//connection to your database
Dw_1. Retrieve ()
End the if

CodePudding user response:

Dw_1. Setfilter (" QJMC like '% %' "+ s +" ")
Dw_1. Setfocus ()//to focus

Dw_1. Settransobject (sqlca)//connection to your database
Dw_1. Retrieve ()

The eldest brother against
Dw_1. Settransobject (sqlca)//connection to your database
Dw_1. Retrieve ()

Dw_1. Setfilter (" QJMC like '% %' "+ s +" ")
Dw_1. Setfocus ()//to focus

CodePudding user response:

Dw_1. Setfilter (" QJMC like '% %' "+ s +" ")
Less a
Dw_1. Filter ()

CodePudding user response:

QJMC records of this field: balance, digital indicator, according to the optometry machine etc.
Scales, digital indicator, according to the optometry machine no common character in the name of this a few, you use character matching expression can not find all of course!
"+ s +" "QJMC like '% %'", when s='light', only QJMC in "light" word can come out, such as the optometry machine, cable, laser, etc., without the balance of "light" word, a digital indicator said won't come out!

CodePudding user response:

Opet98765
According to your method, as long as the input one word can be found out entirely, including records, unrelated or not ah,

CodePudding user response:

Several methods are tried, not feasible

CodePudding user response:

The problem is still struggling with wow?
The are a few days, add my QQ 370801979 take a look at you,