Thanks for the people who helped me to get the issue resolved for my previous post.
lds_data = Create DataStore
lds_data.dataobject = 'd_revoke_certificate_hhg'
ll_total_rows = lds_data.Retrieve()
FOR ll_row_count = 1 TO ll_total_rows
ls_policy_message = ""
// Window - user info and Progress bar management
of_update_status("Working on Form H " + Trim(String(ll_row_count)) + " of " + String(ll_total_rows))
ll_certificate_id = lds_data.GetItemNumber(ll_row_count, "certificate_id")
The result set from the datawindow should be the below certififcate id's.
Issue : The GetItemNumber is returning negative number that is not in the actual resultset of the datawindow.
When I do Quickwatch it shows me the correct number as "2008506173"
but when the value is getting assigned to the ll_certificate_id its showing me as negative number which is not even in the resultset.
Why is the negative number showing in debug mode ?
Can you please help me out from this issue ? It started doing recently and it was working fine earlier.
your help is highly appreciated !!!