Oracle Reserved Words Used with Filter and Expression Text

FDO API

 
Oracle Reserved Words Used with Filter and Expression Text
 
 
 

When using a filter string with Oracle reserved words, the string within the expression must be encapsulated inside single quotes (following the same convention used with the SQL language). Failure to do so will result in a parsing error because the parser cannot determine any difference between the value and the keyword.

Example of a filter string:

AND='linetype' 

This FDO constraint appliesto the Oracle reserved words:

  • AND
  • DATE
  • IN
  • LIKE
  • NOT
  • OR