Stored procedures and queries (HFSQL Client/Server) The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code...... Set of procedures The global procedures are grouped in set of procedures...... Global procedure/function A global procedure can be used in all the processes or events of the project.... Procedure/Function A procedure is used to associate an identifier with a statement block...... Scope of procedures The scope of a procedure defines whether it is public, private, etc...... Procedure (Type of variable) The Procedure type is used to handle: the procedures or methods found in the project. the procedures or methods found in an internal component. the procedures or methods found in an external component.... Before (Property) The Before property replaces or inserts a procedure before the other procedures in: a Procedure variable. an event associated with a control.... After (Property) The After property replaces or inserts a procedure after the other procedures in: a Procedure variable. an event associated with a control.... Extension procedure By using extension procedures, you can add your own WLanguage procedures to different types of variables (string, date, color etc.)...... Coloring the procedures A color (text color) can be assigned to the procedures so that they can be easily classified and identified...... Calling a procedure/a function Syntax for calling a local or global procedure. Declaring a procedure/a function The different syntaxes for declaring a procedure... Local procedure Two types of procedures are available...... Prototype overload/Overload The procedures and the methods of classes can have several syntaxes.... Debugging a connection to an HFSQL server The stored procedures and the triggers are debugged from the environment, with real execution on the server...... The "Code" pane The "Code" pane is used to handle the procedures (local and global procedures) and the classes found in the current project ("Global procedures", "Local procedures" and "Classes" options)...... HListStoredElement (Function) Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). <Connection variable>.ListStoredElement (Function) Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). Optional parameters Some of the parameters passed to a procedure can be optional parameters...... Creating a WINDEV SOAP Server application The SOAP Server application is an application containing all the procedures to run...... Parameter of a procedure/function You have the ability to pass parameters to a procedure.... Zombie procedures In most cases, old code contains procedures that are used but that do no longer match the current quality standard...... Reverse code modeling The reverse code modeling allows you to view in a graph...... Using Java code You can use Java code: in Java applications generated with WINDEV. in Android applications generated with WINDEV Mobile. This allows you to create global procedures in Java.... Internal procedure Several features require a procedure called once or several times via a WLanguage function ("Callback")....