Code Generator

Labels
AJAX(112) App Studio(9) 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(178) 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(184) 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(3) 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
Code Generator
Thursday, December 30, 2010PrintSubscribe
Installation Issues

Code On Time generator is a Windows application that hosts an Internet Explorer web browser within the boundaries of the main window. The code generator navigates to the HTML files stored locally on the hard drive of your computer. HTML files provide interactive user interface of the code generator based on JavaScript. No information is transmitted over the web to our server when you generate your applications. The input and output files of the code generator are stored entirely on your computer.

In a few instances there were reports of the code generator displaying a blank page with Code On Time logo at the top when the generator starts. No other user interface elements were present. Re-installation of the code generator would not help.

The issue has to do with the security settings of Internet Explorer.

Background

Internet Explorer allows controlling if execution of the JavaScript embedded into HTML pages is allowed.

The computer has five security zones,  namely:

(0) Local Machine zone,  
(1) Internet,  
(2) Local intranet,
(3) Trusted sites, and
(4) Restricted sites.

However the Internet Explorer user interface allows users to configure only 4 of the 5 security zones using the Internet Explorer interface.

The Local Machine zone (0), is an implicit zone that exists on the local computer, security settings for this zone cannot be configured using the Internet Options Control Panel.

Any configuration done from the Internet Explorer interface have absolutely no effect on enabling scripts to run within Windows Applications on the local computer (a matter which also affects Code On Time code generator).

Steps to Reproduce

If you save the emphasized text below to the file named "Steps to reproduce.reg" and double-click the file to add the file entries to the registry then the script execution in the Local Machine Zone will become disabled. DO NOT DO THAT !!!Winking smile 

REGEDIT4
 
[HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\0]
 
"1200"=dword:00000000
"1201"=dword:00000001
"1400"=dword:00000000
"1406"=dword:00000000
"1C00"=hex:00,00,02,00
 
[HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings]
 
"Security_HKLM_only"=dword:00000001

Steps to Rectify

If you save the emphasized text presented below to the file "Script Permissions Fix.reg"  and double-click the file to add the file entries to the registry then the script execution in the Local Machine Zone will be allowed. Code On Time generator will start functioning correctly.  

REGEDIT4
[HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\0]
"1400"=dword:00000003
[HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings]
"Security_HKLM_only"=dword:00000001

References

http://support.microsoft.com/kb/833633

This information has been provided courtesy of Gabriel Inya-Agha of Quickening Group.

Monday, December 27, 2010PrintSubscribe
Web App Factory, Multiple Value Filters, …

The latest release of Code On Time generator introduces several bug fixes and new major features.

  • Advanced Filters and Search Bar options have been enhanced to allow adaptive filtering with multiple values. The screenshot below shows the new “include” search bar option that allows selecting multiple values to filter a column.

    image
    Multiple value filter can be activated from the context menu of the column header. The context menu with the highlighted filter option is shown in the picture.
     
  • Web App Factory project now supports ASP.NET 4.0 and ASP.NET 3.5. Projects of this type are generated as a Visual Studio solution with the core application and data controllers placed in a separate class library and application pages hosted in a separate Web Application project. A bare-bones Sandbox project is also included to provide a starting point for developers looking to integrate the core application in their own projects.

The new release will produce applications with EnableCdn property of the ScriptManager set to “False” by default to prevent errors during development without Internet connection.

Rich Editor is now provided with a dedicated host page that prevents a runtime error in Windows 2008 deployments.

Web App Factory provides additional entries that will ensure application operating without errors in Windows 2008 instances of IIS 7 with the new pipeline mode.

Business Objects now support an  advanced version of Select and SelectSingle methods that will allow to use filter expressions to be executed against the database.

Coming Soon

The next release of the code generator will include new Chart and Pivot views. Stay tuned.

Tuesday, August 3, 2010PrintSubscribe
Database Object Selector

Code On Time generator creates database web applications that allow working with all tables and views of your data store. You can limit the number of data objects in your application by excluding those that are not needed in Designer.

The new option allows specifying the scope of your project on Database Connection page of the project wizard.

The following picture shows the project that will include all tables and views.

image

Click on “Select the database tables and views included in the project” link and database object selector will be presented.

image

Make your selection and click OK button.

Continue until you reach the summary of data controllers.

If you are testing this feature with Northwind database then you will see a substantially shorter list of database objects included in the project.

image

Here is the generated ASP.NET 4.0 web application.

image