Grooper Help - Version 25.0
25.0.0017 2,127
  • Overview
  • Help Status

Database Lookup - SQL Query Editor

Code Property Editor Database Lookup Grooper.Core

Edits the SQL query associated with a Database Lookup.

Remarks

Includes code highlighting for SQL syntax and code completion for table names, column names, and keywords. Depending on the DBMS platform in use, code completion also includes common functions for manipulating date time, string, and numeric values.

To leverage advanced DBMS-specific query syntax, build and test the query in the native query builder for the DBMS platform, and then paste it into Grooper.

Notification