Home > database >  Selection problem statement, in PB expression is not valid
Selection problem statement, in PB expression is not valid

Time:10-10

Dec ll_m
If dwo. Name='b_zhutie then
Ll_m=dec (dw_5. Object. M_number [row])
Dw_6. Setfilter (" m_number='" + string (ll_m) + "' ")
Dw_6. Filter ()
End the if

This paragraph I wrote in the BUTTONCLICKED event, a button control in the data window

CodePudding user response:


Dw_6 m_number listed in? What type is

CodePudding user response:

1. Look at the first dw_5. Object. M_number (row) is it possible to get to this value, if it is NULL, the filter must be complains;

CodePudding user response:

M_number column is the number column, the filter inside don't need a single quotes, changed to: dw_6. Setfilter (" m_number="+ string (ll_m))

CodePudding user response:

refer to the second floor qq_17847881 response:
1. Look at the first dw_5. Object. M_number (row) is it possible to get to this value, if it is NULL, the filter must be complains;


Positive solution on the second floor

CodePudding user response:

In the most began to increase line
If the row & lt; 1 then return
To avoid invalid line

CodePudding user response:

Blocking have mistakes in grammar, or the column name is not correct, or value is not correct

CodePudding user response:

Don't single quotes data type is not consistent

CodePudding user response:

Blocking have mistakes in grammar, or the column name is not correct, or value is not correct

CodePudding user response:

Dw_6. Setfilter (" m_number='" + string (ll_m) + "' ") write wrong, should be dw_6. Setfilter (" m_number="+ string (ll_m))
  • Related