Controller - Table Issues

I have a Form with tabs. In one of my tab , I inserted a databound table . It worked fine, until I accidentally removed the SQl from the Controller Rules.
I tried adding the table again and the Controller is not adding/compiling the sql for the new added table. Eventhough I added a new Rule and SQL, the data is not getting populated. "No Data Found" is the error on the page.

Another Issue that I have is it is throwing out errors for form elements that are not in the page anymore (that were removed)

Any help is appreciated.

It is likely that the bindings for the SQL statement are not returning the data in the correct data format for the page display bindings to work. The SQL rules generated include some actions that manipulate the XML structure returned. It is possible that you have lost them?

If you only have limited processing in the Controller for the Database you are trying to use, it may be easier to delete the controller and then add the controller and action again. Then merge the data source fields to the page again, which should re-generate the rules.

Alternatively, add another temporary action and controller to the page and drag on the data source fields as you did originally. This will generate the required rules, which you can then copy across into your existing controller. Once completed delete the new controller.


Can you provide some further information on the second issue?

[/color]

I have a Form with tabs. In one of my tab , I inserted a databound table . It worked fine, until I accidentally removed the SQl from the Controller Rules.
I tried adding the table again and the Controller is not adding/compiling the sql for the new added table. Eventhough I added a new Rule and SQL, the data is not getting populated. "No Data Found" is the error on the page.

Another Issue that I have is it is throwing out errors for form elements that are not in the page anymore (that were removed)

Any help is appreciated.

It is likely that the bindings for the SQL statement are not returning the data in the correct data format for the page display bindings to work. The SQL rules generated include some actions that manipulate the XML structure returned. It is possible that you have lost them?

If you only have limited processing in the Controller for the Database you are trying to use, it may be easier to delete the controller and then add the controller and action again. Then merge the data source fields to the page again, which should re-generate the rules.

Alternatively, add another temporary action and controller to the page and drag on the data source fields as you did originally. This will generate the required rules, which you can then copy across into your existing controller. Once completed delete the new controller.


Can you provide some further information on the second issue?

Thanks for your reply.
The other issue is -- I had previously added Partial Pages and generated the appln. I have removed them since and now if I generate my app, I get Compilation Errors and it is all related to the deleted Partial Pages. There are no SQL's that connects to those pages in the Controller Rules.

That sounds like there may be some corrpution caused when deleting the partial page?

Please provide some further details of the errors that are reported when you click on the "Generate Application" button.
Make a note of the partial page name that shows the error, and then close down WebMaker.

You could then check the main application.xml file to see if there is an incorrect entry for the old page name.
Go to the following directory and open the application.xml file:

C:\Program Files\BizFlow\WebMaker\design\repository\<<Your Workspace Name>>\mvc\<<Your Project Name>>\application

Then do a search for the "Partial Page Name" you are getting errors for when you generate.
There should not be entries for either of the the following:
<page id="Partial Page Name???"
<handler id="Partial Page Name???"

If one appears then it would need to be manually deleted to stop the generation problem.
It would need the entire Partial Page "page" or "handler" XML element (including nested sub elements and closing tag) to be deleted from the application.xm file ... very carefully. You may want to create a copy to a separate temporary location.
Then restart the studio and try to generate the whole application again.