Database transaction types

Database transaction types

You are here:

The SQL Builder supports the SQL Query Statement types SELECT, INSERT, UPDATE and 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.

Select the context menu item Omit Current Schema, followed by selecting the checkbox for SQL statement generation:

Statement generation for database connector
SELECT
  EMPLOYEES.EMPLOYEENUMBER,
  EMPLOYEES.LASTNAME,
  EMPLOYEES.FIRSTNAME,
  EMPLOYEES.JOBTITLE
  FROM EMPLOYEES
    JOIN OFFICES
      ON EMPLOYEES.OFFICECODE = OFFICES.OFFICECODE
Database connector editor

As the statement builds up, the left side will show the result set columns with the SQL datatypes.

Last Updated On May 31, 2018

Comments are closed.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close