No Variable Value After Odbc Query

[invoso.com]

After sql query returned data are not stored in variable.

 

 

log file data:

 

114459.875 28 59 20 db odbc connection open returned.
114459.875 28 59 20 db odbc m_strSQL=[sELECT rr, dlugosc_kolejki, czas_oczekiwania FROM infolinia_fa WHERE id_menu=-515 AND kolejnosc=0 ORDER BY id LIMIT 1]
114459.875 28 59 20 db odbc DataAdapter.Fill init.
114459.875 28 59 20 db odbc DataAdapter.Fill call.



114459.890 28 59 20 db odbc DataAdapter.Fill returned. tsFillTime=00:00:00.0156250
114459.890 28 59 20 db read loop iColIdx=0, sBlob_DbColumn=[], strField_Name=[rr]
114459.890 28 59 20 rv add start RR_rr|0
114459.890 28 59 20 rv add 0
114459.890 28 59 20 rv add start RR_1|0
114459.890 28 59 20 rv add 0
114459.890 28 59 20 rv add start RR_rr_1|0
114459.890 28 59 20 rv add 0
114459.890 28 59 20 rv add start RR_1_1|0
114459.890 28 59 20 rv add 0
114459.890 28 59 20 db read loop iColIdx=1, sBlob_DbColumn=[], strField_Name=[dlugosc_kolejki]
114459.890 28 59 20 rv add start RR_dlugosc_kolejki|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 rv add start RR_2|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 rv add start RR_dlugosc_kolejki_1|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 rv add start RR_2_1|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 db read loop iColIdx=2, sBlob_DbColumn=[], strField_Name=[czas_oczekiwania]
114459.890 28 59 20 rv add start RR_czas_oczekiwania|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 rv add start RR_3|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 rv add start RR_czas_oczekiwania_1|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 rv add start RR_3_1|200
114459.890 28 59 20 rv add 200
114459.890 28 59 20 rv add start RR_RowCount|1
114459.890 28 59 20 rv add 1
114459.890 28 59 20 db completed. SqlQueryType=READER, RowsCount=1, sRv=
114459.890 28 59 20 db completed. iRunWait=1, WavPlayWasStarted=0, WavPlayHasNowFinished=0
114459.890 28 59 20 db completed. iRowsAffected=1
114459.890 28 59 20 FindNextVgmTitleInPathList: next module title is=[kolejkowanie]
114459.890 28 59 20 RunModule_AddToTaskQueue [Evaluate,[kolejkowanie],557]
114459.890 28 59 20 q scr add evScriptEvent 9800 CMD_RUN_SAME_MODULE_AGAIN
114459.890 6 59 20 q scr run evScriptEvent sCode=[CMD_RUN_SAME_MODULE_AGAIN] iActionID=0, crn=0[0|0|0|0|0][|||||] 00:00:00 max:13|00:00:01.2656250
114459.890 6 59 20 scriptevent CMD_RUN_SAME_MODULE_AGAIN 0|0|0 || LineState=LS_DBQUERY
114459.890 6 59 20 t timer clear (force=False)
114459.890 6 59 20 RunModule start Evaluate, [kolejkowanie], iModuleIdx=557, previous: vgm=557, vgs=15:15
114459.890 6 59 20 state [kolejkowanie] Evaluate [$RV[get_menu_1_settings_managermenu_kolejkowanie]]
114459.890 6 59 20 rv replace start [$RV[get_menu_1_settings_managermenu_kolejkowanie]]
114459.890 6 rv dbg rv_retrieve did not find [get_menu_1_settings_managermenu_kolejkowanie] ( 67 65 74 5f 6d 65 6e 75 5f 31 5f 73 65 74 74 69 6e 67 73 5f 6d 61 6e 61 67 65 72 6d 65 6e 75 5f 6b 6f 6c 65 6a 6b 6f 77 61 6e 69 65)
114459.890 6 59 20 rv replace end []
114459.890 6 59 20 eval []
114459.890 6 59 20 objReturn is NULL for input=[], try with Cstr
114459.890 28 59 20 db odbc query completed.
114459.890 6 59 20 eval InvokeMember Eval returned
114459.890 6 59 20 creating new (non-global) rv : RR_dlugosc_kolejki_1
114459.890 6 59 20 Eval Expr result:[] stored in RV[RR_dlugosc_kolejki_1]
114459.890 6 59 20 path {} not found
114459.890 6 59 20 matching path not found [], try boolean paths.
114459.890 6 59 20 FindNextVgmTitleInPathList: next module title is=[kolejnosc_fa_order]

 

 

Why $RV[RR_dlugosc_kolejki_1] not including value : 200?

 

[SupportTeam]

The Evaluate Expression module titled [kolejkowanie] is evaluating $RV[get_menu_1_settings_managermenu_kolejkowanie], not $RV[RR_dlugosc_kolejki_1]

 

It looks like the Evaluate Expression module is told to save the evaluation result to $RV[RR_dlugosc_kolejki_1] - which would oeverwrite any value previously stored in that $RV.,

 

Can you please post the script that is used here.

[invoso.com]

In script I used $RV[RR_2_1] and this var is available, but not $RV[RR_dlugosc_kolejki_1]

 

 

As You see in first post data should be stored in different variable.

 

I can't use data with construction $RV[modulename_headercolumn_recordposition]

but $RV[modulename_columnposition_recordposition] working.

[SupportTeam]

As You see in first post data should be stored in different variable.

Which part of the posted trace are you referring to?

 

The best thing to do would be to post the script at the same time as the trace.

 

We can then see what the script is doing and match that up with the trace.