As title, as follows:
1, sFilter="string (pro_date, 'yyyymmdd')='" + sle_filter. Text +"' "

2, ls_sql=ls_sql + sle_ftext. Text
String SQL='customer="given"'
Dw_1. Setfilter (ls_sql)
Dw_1. Filter ()

. 1 in the statement, the sle_filter text values from the previous statement, why still in sle_filter. And the number plus a + before and after the text, but also with two pairs of quotes, what's going on, I haven't seen the relevant information, you can explain, or provide some information,

Article 2 in the statement, if ftext. The value of the text is a 'given', the ls_sql with SQL result is not the same, but I put ls_sql dw_1 setfilter illegal (ls_sql) prompt expression, and put the SQL dw_1. Setfilter (SQL) to normal operation,

Bother everybody to help explain, especially those two and two pairs of quotation marks is +. What's the matter, look forward to your reply, thank you

CodePudding user response:

When you write a query is not the case?
Select * from student where name='tonny'

Caused to the equivalent of the character data, the value is the character,
String ls_sql
='given' ls_sql="customer", "
It generated conditions is the where the customer='given'

CodePudding user response:

+ number is string concatenation, quotes represent the content of the quotes is when the character to deal with,
Such as "1" + "2", after the spell is "12", if there are no quotes result is 3.

CodePudding user response:

You can have a good count note finally a plus sign the back of the middle is a pair of double quotes a single quotation so string inside there is a single quotes,,

Such as you. You need a s_ls=sle_1 text

Should be written in SQL="s_ls=" + "'" + sle_1. Text + "'"

SQL=string + single quotes + variable + single quotes,,