Use Value as a Literal

The Use Value as a Literal selection, on the Assign Condition dialog box, places text in the query exactly as it appears in the Value is box. In most cases, you should not select this option so that the Query Builder can determine the correct SQL statement. However, in some instances, advanced users may want to type specific text that should be written directly to the SQL statement.

For example, you can type a system function specific to the database (such as GETDATE on a Microsoft SQL Server database) and select Use Value as a Literal. This ensures that GETDATE is included in the SQL statement without quotation marks.

Related Topics

Query Builder Overview

 

 

What's New in this Release

 

For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at documentation@infor.com.