Skip to main content

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

Hi @hweerasinghe 

Please can you give a screenshot of the error and your SQL statement?

 

Hi @hweerasinghe 
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.

Hi @hweerasinghe 

IFS solution 294211 will resolve the issue. 
Please raise a support ticket to proceed with this solution.
Its UPD13 bug fix.

 

Reply


Terms & ConditionsCookie settings