Database transaction types
The SQL Builder supports the SQL Query Statement types
DELETE. If the statement syntax does not match these types, the SQL builder helper parts are disabled. The SQL syntax is always verified and errors are shown with red squiggly underlines. Hover the mouse over this location to display a tooltip which will indicate the current problem. To re-enable the SQL Builder, correct the SQL syntax and make sure to have the correct types that are listed above.
the context menu item Omit Current Schema, followed by selecting the checkbox for SQL statement generation:
Statement generation for database connector
ON EMPLOYEES.OFFICECODE = OFFICES.OFFICECODE
As the statement builds up, the left side will show the result set columns with the SQL datatypes.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.