Navigation
Records in this category
- Is there a way to copy information (controls, fields, and their properties) from existing Pages into new Pages?
- Can a schema (XSD) be used at design-time to create pages and establish bindings, and then at runtime connect to a web service that uses a WSDL?
- Can an XSD be used to design pages that are communicating with a web service at runtime that actually returns a single string in the response (the contents of which is XML conforming to the XSD)?
- How do you create a dynamic table that allows the user to add rows as required?
- Is it possible to have more than one skin used in the application? Obviously, only one skin would be used at a time, but can the skin be changed based on some runtime data?
- How can you check if the user updated any fields on a form?
- How is the length of field labels configured?
- Can a page be rendered in two modes (display only and editable) depending on some runtime data?
- How can list paging be implemented? For example, paging through the results of a search query.
- Does MVC WebMaker support creating drop-down menus?
- Can a page be created using information from multiple web service calls?
- Can parameters be passed to an application using the URL query string?
- Why do I get an error stating 'Variables may not be used within this expression' when entering XPaths?
- Is it possible to dynamically change the page to display based on some runtime data?
- Can I include my own JavaScript functions in the pages generated by FormMaker?
- Is there an #Include feature in MVC WebMaker or anything similar to it?
- Can I change the External Editor that is invoked by MVC WebMaker?
- Customising the Generated AJAX Calls
- How do I use the Editable Row control?
- How do I use the Paging Table control?
- How do I use the Tree control?
- How do I access event information in custom script actions?
- How do I handle changes to data sources (SQL tables, Web Services, etc) that have already been used for page design?
Tags
WebMaker Studio » FormMaker
How do I handle changes to data sources (SQL tables, Web Services, etc) that have already been used for page design?
Within FormMaker, the Page Structure screen provides the option to easily use data sources to design pages.
When you do this, it takes a 'snapshot' of the details of this data source to setup the XML data structures used for binding, along with the controller rules needed to successfully integrate with it.
If you change the details of the data source (eg add additional columns to a SQL table) at a later point, there are a couple of steps that will need to be taken to ensure the updated information is correctly reflected in your application.
Firstly, you should use the Page Structure screen to bring up the updated data source information on the right hand side. (If you are using some kind of webservice then you will need to first upload the most recent WSDL or schema file.) You can now drag the additional fields onto your page as required.
Now go to the Data Bindings screen, and use the 'edit' link on the right hand side to edit the contents of the XML document. You will need to manually add in the elements for the additional fields in the appropriate place.
If you are submitting information from the page for this data source (eg for a web service request, or some kind of database edit) then you will also need to perform this step for the submission document for each action from this page by using the Action Submission Bindings tab.
Finally, you may also need to adjust some of the rules generated in the controllers for interacting with your data source. The most common reason would be to update an insert or update SQL query with the details of the new columns. You can open the rules from the Application Map screen by right clicking on the controller called from the page and choosing the 'Controller Rules' option. You can now manually adjust the SQL query, and then populate the new SQL parameter values using drag and drop from the document on the left hand side.
You should now be able to generate and deploy your application and use it with your updated data sources.
Tags: data source, sql
Related entries:
- Installing behind proxy servers
- What port numbers are used by the web servers included in the hyfinity products?
- Problems due to existing Tomcat installations.
- Running the Tutorial web services locally
- Deploying MVC WebMaker on IBM WebSphere
Last update: 2010-07-09 16:00
Author: Hyfinity support team
Revision: 1.0
You can comment this FAQ