Symptom
An empty result set is generated when using selections such as the following:
({PA0002.GBPAS} <= Date(0,0,0) or {PA0002.GBPAS} > CurrentDate)
The problem occurs because the information is passed to the driver as the following (in pseudo code):
!({PA0002.GBPAS} > Date(0,0,0) and {PA0002.GBPAS} <= CurrentDate).
The OpenSQL driver misses the initial and all-encompassing negation.
In the example above, instead of discarding the middle interval, it discards everything outside the interval.
Read more...
Product
Keywords
CE CHF 521291 OPENSQL OPEN SQL DRIVER SAP NULL RECORD RESULT SET BusinessObjects Enterprise SAP OpenSQL driver , c2018513 , KBA , BI-BIP , Business intelligence platform , Bug Filed
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.