Hi, thanks for reading. Transformer stage is giving this error.
APT_CombinedOperatorController,0: Null string argument. [transform/tfmop_functions.C:1071]
Here is our logic
2 stage variables
logic for svAddr1Null - If IsNull(Policy_Info_In.CO_ADR1) Then 1 Else 0
logic for svChkAddr1Null - If svAddr1Null = 0 Then (If Num(Left(Policy_Info_In.CO_ADR1,2)) Then 1 Else -1) Else -1
if we remove svChkAddr1Null we don't get the warning. The logic is doing exactly what we want, but we need to get rid of the warnings. I know we can use a message handler, but wanting to know if there is another way to get rid of the warning? Thanks for any help you can offer.
APT_CombinedOperatorController,0: Null string argument
Moderators: chulett, rschirm, roy
Re: APT_CombinedOperatorController,0: Null string argument
Try with below derivation.
svChkAddr1Null - If svAddr1Null = 0 Then (If Num(Left(Trim(Policy_Info_In.CO_ADR1),2)) Then 1 Else -1) Else -1
svChkAddr1Null - If svAddr1Null = 0 Then (If Num(Left(Trim(Policy_Info_In.CO_ADR1),2)) Then 1 Else -1) Else -1
Cheers
Ravi K
Ravi K
Re: APT_CombinedOperatorController,0: Null string argument
Could CO_ADR1 contain an empty string (not flagged as null but not containing data)? Check for an empty string as part of the Null logic for svAddr1Null: if IsNull(Policy_Info_In.CO_ADR1) then 1 else if Len(Trim(Policy_Info_In.CO_ADR1) then 1 else 0Marley777 wrote:
APT_CombinedOperatorController,0: Null string argument. [transform/tfmop_functions.C:1071]
logic for svAddr1Null - If IsNull(Policy_Info_In.CO_ADR1) Then 1 Else 0
logic for svChkAddr1Null - If svAddr1Null = 0 Then (If Num(Left(Policy_Info_In.CO_ADR1,2)) Then 1 Else -1) Else -1
if we remove svChkAddr1Null we don't get the warning. The logic is doing exactly what we want, but we need to get rid of the warnings. I know we can use a message handler, but wanting to know if there is another way to get rid of the warning? Thanks for any help you can offer.
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
Instead of piggy-backing on someone else's post, please create your own and reference the original post with a link. While your situation may be very similar, it is also unique to some degree and may warrant a slightly different solution.
Have you tried the solution posted in the original thread? Num() gives this error when the supplied column is empty or null, therefore appropriate empty/null handling should be performed.
Regards,
Have you tried the solution posted in the original thread? Num() gives this error when the supplied column is empty or null, therefore appropriate empty/null handling should be performed.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.