Base Form
Basic Components
As web application developers, we normally take four steps to create a web form in a web application, and those four steps are repeated many times in the similar ways in many web applications:
  • Query data from the database;
  • Display the data using various web controls;
  • Apply security control if necessary;
  • Write stored procedure to save user submitted data.
Logicweb Studio formulates those web forms as Base Forms, makes the above four steps configurable and easy to manage. A Base Form has the following six configurable components:
  • User Interface: user interface consists all or some of the following four groups of elements: navigation bars, menus, toolbars and data fields. Logicweb Studio provides professional web control set, such as Lookup control, Date / DateTime picker control, Editable Select control, Phone Box, Email Box, URL Box, Number Box, and more;
  • View SQL: View SQL feeds a data set object which binds to the base form's form fields. The View SQL can be a simple SQL select statement, or a stored procedure with sophisticated logic;
  • Save Logic: A stored procedure to handle creating and updating record. When user submits the base form by clicking Save or Save and Close button, Logicweb Studio will automate the following processes: validate the user input at client side, transfer data to the web server in XML format string, and then flow the data to the stored procedure.
  • Status Modifier: When data presentation is depended on the status of the data, use Modifiers.
  • Security Control: Permission keys can be used to secure any element in base forms. To access an element which is protected by permission PERM-XYZ, the application user must be granted the same permission PERM-XYZ. Application user can be granted permissions through his/her role, while any permission can be also assigned to or revoked from an individual user.
  • Form JavaScript: This is an optional component. Logicweb Studio provides default JavaScript functions; if you want to customize the solution, you may add more functions and write your own JavaScript.
Basic Form Attributes
  • Form Name: Name of the base form;
  • Form ID: Internal form id, form id 1-1000 has been reserved as Logicweb Studio system base form;
  • Notes: Base form description;
  • Save SP Name: Stored procedure for the base form's Save Logic;
  • User Object: User object for which the base form is built;
  • View SQL Type: Indicate the View SQL is a select statement or a stored procedure; it is used to retrieve data for existing record;
  • View SQL: Valid select statement or stored procedure name;
  • Initview SQL Type: Indicate the Initview SQL is a select statement or a stored procedure;
  • Initview SQL: Optional, valid select statement or stored procedure name; it is used to initialize data fields when creating new record;
  • Full Access: Full access permission key;
  • View Access: View access permission key; it applies when full access is not given.
  • Form Style: Indicate if the pop-up web form is a standard web form or a dialog-box style web form;
  • Navigation Bar: Indicate if the web form has a navigation bar frame;
  • Width: Width of the web form in pixels;
  • Height: Height of the web form in pixels;
  • Button Title: This button section is for the grid view which will use this base form to create and update records; this button title is the title of the create new button;
  • ToolTip: ToolTip of the above discussed button;
  • Button Image: Image of the above discussed button;
  • CheckOut By: Developer must checkout a base form before he can modify it; CheckOut By is the one who currently checks out this base form;
  • JavaScript: Custom JavasSript;
  • Form Help: Help content for this base form;
Toolbar Buttons
  • Save: Only changed data will be submitted to web server; the web form will remain open after submitting;
  • Save and Close: Only changed data will be submitted to web server; the web form will be closed after submitting, if no error occurs;
  • SQL & JS: Hints on how to create View SQL, Save Stored Procedure, and custom JavaScript function names;
  • Set Values: Set record id and or parent id for preview function;
  • Preview: Preview the base form;
  • Close: Close window;
Navigation Bars
A base form has the following child records: tabs, sections, fields, menus, toolbars, optionally, navigation forms and modifiers. You can access these records from the base form's navigation bars:
  • Tabs: List of base form's tabs; tabs are analogous to the pages of a Windows application's tab controls, or the labels in a file cabinet. A base form can host multiple form tabs for the same area;
  • Sections: List of base form's sections; sections is the next level container under the tab to host a certain type of information or a group of web fields;
  • Fields: List of base form's fields; fields are basic web form elements which are grouped under Sections;
  • Menus: List of base form's menus, including system predefined menus and custom menus;
  • Toolbars: List of base form's toolbar buttons, including system predefined toolbar buttons and custom buttons;
  • Navigations: List of base form's navigation forms;
  • Modifiers: List of base form's modifiers.