Indentyfing Data From Database

[invoso.com]

I try to identify null value in $RV. VG not recognizing null value getted from DB in evaluate expression.

 

How to detect null value in Evaluate Expression?

 

Other problem: in one EE module VG not detecting _{value to find path.}

 

<sub>130837.836 7 28 10 RunModule start Evaluate, [eliminate timeout], iModuleIdx=1021, previous: vgm=1021, vgs=18:18
130837.836 7 28 10 state [eliminate timeout] Evaluate [$RV[get_menu_1_settings_managermenu_akcja]]
130837.837 7 28 10 rv replace start [$RV[get_menu_1_settings_managermenu_akcja]]
130837.837 7 28 10 rv replace end
130837.837 7 28 10 eval
130837.836 264 28 10 db odbc query completed.
130837.838 7 28 10 VGMTYPE_EVALEXPR InvokeMember Eval Exception : Exception has been thrown by the target of an invocation.
130837.838 7 28 10 eval InvokeMember Eval returned
130837.838 7 28 10 rvns add eliminate timeout_Input|SUB
130837.838 7 28 10 rvns add eliminate timeout|
130837.839 7 28 10 Eval Expr result:[]
130837.839 7 28 10 matching path not found [], try boolean paths.


131045.221 7 7 3 RunModule start Evaluate, [eliminate timeout], iModuleIdx=692, previous: vgm=692, vgs=12:12
131045.222 7 7 3 state [eliminate timeout] Evaluate [$RV[get_menu_1_settings_managermenu_akcja]]
131045.222 7 7 3 rv replace start [$RV[get_menu_1_settings_managermenu_akcja]]
131045.222 7 7 3 rv replace end [EX]
131045.223 7 7 3 eval [EX]
131045.220 274 7 3 db odbc query completed.
131045.223 7 7 3 objReturn is NULL for input=[EX], try with Cstr
131045.224 7 7 3 eval InvokeMember Eval returned
131045.224 7 7 3 rvns add eliminate timeout_Input|EX
131045.225 7 7 3 rvns add eliminate timeout|EX
131045.225 7 7 3 Eval Expr result:[EX]
131045.226 7 7 3 path {EX} found (at offset 129)
131045.226 7 7 3 FindNextVgmTitleInPathList: next module title is=[update polaczenia po txt]
131045.226 7 7 3 t timer clear (force=False)</sub>

 

_{In paths:}

_{on {SUB} goto [update polaczenia po txt]
on {EX} goto [update polaczenia po txt]}

[SupportTeam]

In the Evaluate Expression module please try using quotes around the $RV being evaluated, like this:

 

"$RV[get_menu_1_settings_managermenu_akcja]"

[invoso.com]

With quotes working properly.

 

How to identify empty (null) value of variable )to sign "true" for path?

 

Data in database is NULL so how to store NULL in VG variable?

 

111811.609 7 28 10 eval InvokeMember Eval returned
111811.609 7 28 10 rvns add eliminate timeout_Input|""
111811.609 7 28 10 rvns add eliminate timeout|
111811.610 7 28 10 Eval Expr result:[]
111811.610 7 28 10 matching path not found [], try boolean paths.
111811.610 7 28 10 FindNextVgmTitleInPathList: next module title is=[update polaczenia po txt]
111811.610 7 28 10 matching path found (Boolean False)
111811.610 7 28 10 t timer clear (force=False)

[SupportTeam]

Can you please post a fuller trace?

 

Looks like the path taken was the fail/false path, which seems appropriate in this case.

Any reason why you would not want to use the fail/false path?

[invoso.com]

In case I'm looking for "null" value and not listing any possibly value in path.

 

Or how to detect $RV has any not empty value?

[SupportTeam]

Please post the full trace capturing the call and advise which RV is assigned the returned null data.

 

(Most likely the $RV would be actually assigned a zero-length string for any null values).