Having a problem with my WebReports code
Asked 5 months ago
Modified 1 day ago
Viewed 139
times
Asked By Vijay Bonda
0
I'm having a problem with my WebReports code. I have a script that runs a sub-webreport, and then a for loop processes the results. It works perfectly in version 24.4, but in version 23.2, the loop seems to be reading the data character by character instead of by record. Any ideas on how to fix this so I can parse the data properly?
Answers
0
SELECT TO_CHAR(auditdate, 'DD/MM/YYYY HH24:MI') AS "Change Time"
FROM DAuditNew
WHERE dataid = 77390
AND subtype = 144
AND auditid = 10
AND auditdate >= SYSDATE - INTERVAL '4' HOUR
ORDER BY auditdate DESC
FROM DAuditNew
WHERE dataid = 77390
AND subtype = 144
AND auditid = 10
AND auditdate >= SYSDATE - INTERVAL '4' HOUR
ORDER BY auditdate DESC
Answered by Fayaz S T 5 months ago
Your Answer
Latest Topics
💬 0 Answers • 👁️
15 Views
💬 0 Answers • 👁️
115 Views
💬 0 Answers • 👁️
160 Views
💬 0 Answers • 👁️
152 Views
💬 0 Answers • 👁️
152 Views
