Visual Code Editor

Comment: represents the comment of the object that follows.

Empty token: here you must insert a block, a statement, or an expression, depending on the context.

Object icon: the icon of the object involved in the statement.

Name: the name of the selected object.

Column alias: the name used as an alias for the query column in the SQL code generated.

Linked variable: the variable in which the result of this query expression will be stored.

Assignment: the assignment operator used to store the result of the expression in the variable.

Field to be assigned: the field indicated will be saved in the variable specified on the left side.

Alias: the alias of the table selected in the query.

Begin list of parameters: the open parenthesis that demarcates the beginning of the list of parameters for the method.

End list of parameters: the close parenthesis that demarcates the end of the list of parameters for the method.

Code block: indicates the type for the code block selected.

Open curly bracket: the curly bracket that marks the beginning of the code block.

Close curly bracket: the curly bracket that marks the end of the code block.

Object name: the name of the object referenced by the statement.

Point: separates the object name from the method to be invoked.

Method/property name: the name of the method invoked or the property referenced.

AS: separates the expression from the name of the column and the alias.

Comment: represents the comment for the object found to the left of the text.

Expression token: a token that is part of the expression. The underlining of tokens near the one selected indicates which part of the expression is identified by the latter.

Outer join: the asterisk indicates that the filter expression must be understood as an outer join, in which the missing side is the one where the asterisk will be placed.

Static: this modifier indicates that the method is static therefore can be invoked by referencing the class and not one of its instances.

Private/Public: indicates the accessibility type of the method.

Type returned: specifies the type of data returned by the procedure. It can be a scalar type, a class, or a library. If void is entered the procedure won't return any value.

New/Null: new indicates that the variable references a newly created object, and null that the variable does not reference any object.

Type of variable: identifies the variable type. Can be a scalar type, a class, or a library.

Optional: this modifier indicates that the parameter is optional.

Inout: this modifier indicates that the parameter is an input/output.

Length: indicates the length of the variable. Important for procedures defined at the database level.

Optional value: indicates which value the parameter should take when it is not sent to the method.

Type of query: identifies the type of query specified in this statement or code block.

Distinct: this modifier indicates that the query cannot return lines that are identical to each other.

Outer join: indicates that the table indicated on the right is linked in left outer join with the previous ones.

For update: indicates that the query is run setting write lock instead of read lock. Using it in a transaction ensures that no other process can edit the selected records until the transaction is complete.

Table selected: represents a table or view added to the from list for this query. In the case of update, delete, or insert queries, it represents the table in which the data will be modified.

From list: the list of tables from which the data returned by the query will be taken.

Where clause: the list of filter conditions applied to the query. Each expression is considered in AND with the others; join expressions among tables may not be expressed if they are handled automatically by In.de.

Order by: the list of order by clauses for the query results. You can order on just one or on multiple columns in the query's select list.

Order by: represents an order by clause for the query results.

Group by: the list of group by clauses for the query results. This is not normally specified because In.de can generate the Group By clause automatically.

Collapsed block: the content of the code block is hidden. Double click here to expand the block and make it visible again.

Throws exception: indicates that the exceptions generated by the method will be raised to the caller; if not specified these will be handled locally.

Throws exception: indicates that the exceptions generated by the event will be raised to the caller; if not specified these will be handled locally.

Document type contained: represents the type of documents contained in this collection.

Writing here: changes the name of the object selected.

Writing here: changes the comment for the object selected.

Writing here: you can insert the following tokens: public to obtain a public method, private for a private method, static to get a static method, and throws if you want any exceptions that occur to be fired to the caller and not handled locally.

Writing here: changes the type returned by the method. You can enter void to get a procedure that doesn't return any value; int, string, date... to return a value or the name of a class or a library to return an object. Press space to get a list of the possible tokens you can insert.

Writing here: changes the type of parameter; you can insert a data type (int, string...) or the name of a class or library. Insert optional to get an optional parameter, or inout for an input/output parameter. Press space to get a list of available tokens.

Writing here: changes the type of variable; you can insert a data type (int, string...) or the name of a class or library. Press space to get a list of available tokens.

Writing here: changes the default value of the variable. Inserts a constant value of the same type as the variable.

Writing here: changes the initial value of the variable. Inserts a constant value of the same type as the variable.

Writing here: changes the expression, adding a token or replacing the current one. If you have selected a function or an operator, the token will be added unless you press the Insert key on the keyboard, which will always trigger a replacement. If you write order by you can add an order by clause for this expression. Finally, you can add a sub query, if allowed in the current context.

Writing here: changes the expression, adding a token or replacing the current one. If you have selected a function or an operator, the token will be added unless you press the Insert key on the keyboard, which will always trigger a replacement.

Writing here: overwrites the token in the formula instead of replacing it. The thicker underline indicates that you have activated overwriting by pressing Insert on the keyboard.

Writing here: you can change the object to which the selected method will be applied. Start typing its name, or drag it from the objects tree with drag&drop.

Writing here: you can change the method invoked on the object that precedes it in the expression. Start typing its name, or press space to see a list of available methods.

Writing here: changes the variable associated with this expression. If you write the name of a new variable, you can create one on the fly; you can also enter * to create a new variable on the fly without needing to provide a name for it.

Writing here: you can add a table to the from list for the query. Start typing the name or drag the table here from the object tree.

Writing here: changes the type of query or adds special clauses like where, distinct, or union. Press space to see the list of tokens available and choose the one you want.

Writing here: changes the table from which you want to delete the rows with another, writing its name. Press space to see the list of available tables.

Writing here: you can add a new field to the select list by writing its name, or you can change the table on which the query runs, or you can change the alias to the current one.

Writing here: you can replace the table selected in the query with another one, or you can add a field in the table to the select list by writing its name. You can also change the alias of the selected table by writing whatever new one you like. Finally, you can insert outer join to change the join type, or for update to activate the write locks instead of the read ones.

Writing here: changes the alias of the table selected in the query.

Writing here: changes the order by direction. Enter desc for descending order, or asc for ascending order. The icon alongside the order by clause indicates the order by type.

Writing here: changes the maximum length of the variable. Inserts an integer in the valid interval depending on the type of variable in play.

Writing here: you can add the token throws if you want any exceptions that occur to be fired to the caller and not handled locally.

Writing here: changes the type of objects contained in the collection of documents. Write the name of the class, or press space to see the list of types available.

If you press Enter: adds a parameter to the function. You can also drag a table field by holding down Shift to create a parameter than can contain the field value.

If you press Enter: adds a where clause to the query to filter the data. All the expressions contained in the where clause must be considered in AND.

If you press Enter: adds a new expression to the query's select list.

If you press Enter: adds a new variable to the procedure. You can also drag a table field using drag&drop to add a variable that can contain the value of that field.

If you press Enter: adds a statement before the one selected.

If you press Enter: adds a statement after the one selected.

If you press Enter: adds a CASE block.

If you press Enter: adds a statement after, resetting the CASE block to normal.

If you press Del: deletes the inout clause, making the parameter input only.

If you press Del: deletes the optional clause, making the parameter mandatory.

If you press Del: deletes the selected token from the formula.

If you press Del: deletes the right side of the assignment, zeroing the expression to assign to the variable.

If you press Del: clears all tables from the from list for the query.

If you press Del: deletes all the Where clauses.

If you press Del: deletes the comment associated with this object. For comments inside the code, if the comment is empty and you press Del again, the entire comment line will be deleted.

If you press Del: deletes the outer join clause, changing the join type to inner join.

If you press Del: deletes the for update clause from this table selected in the query.

If you press Del: deletes the alias of the table selected.

If you press Del: deletes the outer join indicator from this filter expression.

If you press Del: deletes the part of the code you have selected.

If you press Del: deletes the distinct clause.

If you press Del: deletes all the order by clauses.

If you press Del: deletes all the manual group by clauses.

If you press Del: deletes the static modifier. The method will only be accessible by referencing an instance of the class.

If you press Del: deletes the throws clause. Any exceptions will be handled locally at the method and will not be raised to the caller.

If you press Del: deletes the code block after the CASE so that it becomes part of the following CASE clause.

If you press Del: the collection will no longer contain specific documents, only generic ones.

Note: press / to add a comment to this object.

Note: press . to list the methods that can be used here.

Note: press . to add a call to a method of the object.

Note: Ctrl-Pg Up or Ctrl-Pg Dn: shows/hides the content of the block.

Note: press / to comment the code or not. Press Ctrl-Up or Ctrl-Dn to move the code to the same level, or Ctrl-Shift-Up or Ctrl-Shift-Dn to move the code to nested levels as well.