SAP Knowledge Base Article - Preview

3085513 - Handwritten SQL No Longer Works

Symptom

Handwritten SQL that performed correctly prior to BI 4.2 SP 8 throws an "Invalid expression" error in SP 8. For example:

SELECT MyTable.MyColumn MT1 IN (SELECT MT1.OtherColumn WHERE MT1.OtherColumn='X')


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.2 Support Pack 8
  • Information Design Tool (IDT)

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

sql fhs freehand free hand written custom specific encoded encode decoded decode evaluate evaluated substituted executed , KBA , BI-BIP-IDT-CX , Connection Layer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.