Previous Topic: Open the Inline Code DialogNext Topic: Declare Variables


Inline Code Statements with ODBC/JDBC/ADO.NET

The inline code statement lets you add custom code or SQL statements including ODBC/JDBC/ADO.NET statements in an action diagram. Statements that contain only SQL statements are more straightforward to create as the database pre-compiler will convert the SQL into language dependent source code. ODBC/JDBC/ADO.NET code is written directly in the target source language and thus requires more coding than SQL statements alone.

Consider a scenario of performing CRUD operations over an entity EMPLOYEE with the following schema:

Entity EMPLOYEE
Attribute NUMBER number(6) primary key
Attribute NAME text(30)
Attribute WORK_PHONE text(16) optional