Reload at each row

[Anonymous]

Whether reload at each row supports for postgresql.It is showing sysntax error at globalMap.get()

[Anonymous]

Hi,
for me, your query should be :
"SELECT OSD_SURG_ID,OSD_SURG_START_DT_TIME,OSD_SURG_END_DT_TIME,OSD_CRT_DT,OSD_CRT_UID,OSD_UPD_DT, OSD_UPD_UID, OSD_MR_NUM, OSD_AUTH_UID, OSD_AUTH_DT
FROM OT_SURGERY_DETAILS where OSD_MR_NUM = '"+ (String)globalMap.get("row1.OAD_MR_NUM") +"'"

or "+ (String)globalMap.get("row1.OAD_MR_NUM") if it's a number


Assuming that row1.OAD_MR_NUM is the variable that comes from tMap as i explain it here

[Anonymous]

hai 
 It is working but the data is not validating means it showing as zero rows while reload at each row

[Anonymous]

All database input components provides a return value QUERY . Checkout the Outline view. This return value contains the actual fired statement and here you will find the problem.