Query_dbf. You. Fields [' df '+ month_str1]. The Value 1 - June is worth, but 7-12 months is not worth it, how to deal with

 
Qm_value:=qc_value + GetFloatValue (vartostr (query_dbf. You. Fields [' df '+ month_str1] Value)) - GetFloatValue (vartostr (query_dbf. You. Fields [' jf' + month_str1] Value)); 

Qm_sl:=qc_sl + GetFloatValue (vartostr (query_dbf. You. Fields [' DFSW + month_str1] Value)) - GetFloatValue (vartostr (query_dbf. You. Fields [' JFSW + month_str1] Value)); 

CodePudding user response:

Upupup, a great god genuflect is begged directions

CodePudding user response:

someone baa ~ ~

CodePudding user response:

Is simple when you query for 1 - December field processing, NZ (MONTH, 0), null, replace with 0,

Program, the seemingly empty Value when used. The Value will be an error, but with the asstring not an error, so we can judge the asstring whether Value is empty, again. The Value Value

CodePudding user response:

reference yangb0803 reply: 3/f

is simple when you query for 1 - December field processing, NZ (MONTH, 0), null, replace with 0,

Program, the seemingly empty Value when used. The Value will be an error, but with the asstring not an error, so we can judge the asstring whether Value is empty, again. The Value Value

Could you tell me how to write the specific code that (even though it's o?

CodePudding user response:

Please send your related table field name, type, what agreement is null, the need to determine that a few field is empty, so to help you through the SQL statements, to make a choice,