Blog: Posts from July, 2012

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Posts from July, 2012
Monday, July 9, 2012PrintSubscribe
Overview of Commands

A command provides a developer-friendly dictionary of SQL expressions that correspond to the individual fields and also define the base table and joined tables. The application framework uses the command text elements to compose Select, Update, Insert, and Delete statements at run-time.

Command Properties:

Property Description
Controller Specifies the controller that the command belongs to.
Event Specifies which event that causes the command to execute.
Id Specifies the unique identifier for the command.
Table Name Specifies the table name to be used in automatically constructed Insert, Update, and Delete operations.
Text Specifies the text of the command.
Type Specifies the type of the command.

Learn how to work with commands in the Project Designer.

Learn to drag and drop commands in the Project Explorer.

Monday, July 9, 2012PrintSubscribe
Working with Commands in Designer

Commands are used by the controller to select data.

Commands can be accessed by selecting a controller and switching to the Commands tab.

List of commands in the Project Browser.

The context menu option List on the Commands node in the Project Explorer will also navigate to the list of commands.

List context menu option on Commands node in the Project Explorer.

A command can be located by entering the command Id and controller Name in the configuration navigator.

A command located in the project configuration navigator.

Clicking on the Id or using the context menu option View in the list of commands will navigate to the properties page of the command.

View context menu option in the Project Browser.      Properties page for a command in the Project Browser.

The Sync context menu option will select the relevant project configuration node in the Project Explorer.

Sync context menu option in the Project Browser.     Command1 node selected in the Project Explorer.

The command Id can be changed using the Rename context menu option in the Project Explorer.

Rename context menu option in the Project Explorer.

The Controller of the command can be changed by dragging the command node.

Dropping command1 on Commands node of Order Details.     Command dropped and renamed under OrderDetails controller.

Commands are recreated by the web application generator every time the baseline is refreshed. If the developer modifies the command, automatic recreation will no longer occur, and the developer must update the command by hand.

The “Reset to Baseline” context menu option will restore the command to baseline state.

Context menu option Reset to Baseline in the Project Explorer.

Monday, July 9, 2012PrintSubscribe
"Code” and “JavaScript” Business Rules, Inclusion and Exclusion of Pages From Menu

Code On Time release 6.0.0.30 includes the following new features and enhancements:

  • Developers can use designer to create “Code” business rules implemented in C#/Visual Basic. The application generator will create a file with the business rule implementation. The file will not be overwritten by subsequent code generation sessions. New application framework class RuleAttribute links the business rule to the code.
     
    'Code' Business Rules are now automatically generated in all projects types and all product editions
     
  • Sophisticated JavaScript Business Rules can now be used to implement complex validation and just-in-time correction of user input.
     
  • Project Explorer offers a new context menu option “Exclude From Menu” to hide the page from the navigation menu.
     
  • Project Explorer offers a new context menu option “Include in Menu” to show the page in
    the navigation menu.
     
  • New "View in Browser" action is available in Project Explorer in the context menu of pages.
  • Mandatory "radio button list" will require user to make a selection of an option when inserting or editing a record.
     
  • Read-Only fields are passed to the business rules when actions are executed in the views with the type other than the "form" view.
     
  • Virtualization node set now features IsEmpty property. The property value is 'true' if the node set is empty.
     
  • The chained calls to CreateAction will correctly create multiple actions.
     
  • Clicking on the "View Details" arrow icon in the lookup window will not close the lookup window.
     
  • Property AutoSelect when set to "true" for a lookup field will automatically activate the lookup on data entry if the field is blank.
     
  • Enhancements to the "focus" processing with business rules in form views.
     
  • Command Text is correctly saved in Designer.
     
  • The client library will validate argument values before executing Report action. This will ensure that "read-only" values passed as arguments of business rule methods.
     
  • DotNetNuke Factory uses cases-insensitive filter when publishing deployment files.
      
  • Property AquarimExtenderBase.ServicePath is now virtual. Class DataViewExtender is declared as "partial", which allows global overriding of the application service path.
      
  • "Confirmation" controllers are working correctly again. 
      
  • New page name entered in a camel notation will result in "pretty" path and title.
     
  • "Generate" and "Browse" actions will not crash if IIS Express is not install.
     
  • Browsing a page with a non-blank "External Url" property will open the default page of the app instead of trying to open a non-existing page with the name of the page node.
     
  • The issues with Auto Complete Anywhere is resolved.
     
  • The Generate/Browse bug in Designer when a node is not selected is fixed.