If I try to create a SQL statement QR (IFS10) with column titles longer than 32 characters, it will give an error. Has anyone seen this before? Is there a workaround to this problem please?
Thanks
Hiroshan
Userlevel 7
+18
Hi
Please can you give a screenshot of the error and your SQL statement?
Userlevel 7
+18
Hi
I’ve tried same in a IFS 10 Core reference environment and its working fine there.
Seems its related to the oracle version which used for the application.
To confirm that, could you please try below SQL query in database end?
from PLSQL.
SELECT '1' AS "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567" FROM dual
Also try this in SQL Query tool in IFS Application?
Both db end and IFS SQL Query Tool work fine. I need it to work as a QR.
Userlevel 7
+18
Hi
IFS solution 294211 will resolve the issue.
Please raise a support ticket to proceed with this solution.
Its UPD13 bug fix.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.