Showing posts from June, 2012

Formspider vs. Apex

Every product is built to solve a problem. Before its implementation, its creators ask a question and come up with an answer which is the product. How should we stick nails to a wall was the question the creator of the hammer asked.

This question can be asked pragmatically by looking back in time. For example, for centuries humans asked how can we travel faster and decided to breed faster horses. Then Henry Ford came along. He asked the same question, looking into the future and came up with the automobile.

Back to our case, Apex is first built in early 00’s looking back in time and asking the question: “How do people write web pages?”.

Formspider is first built in 2008, looking into the future and asking the question: ”How should we build applications?”.

These two are fundamentally different questions and as a result you get fundamentally different products.

The question it answers is engraved in the essence of the product. No matter what you do, you cannot escape it. You can change dir…

Advanced Data Grid with PL/SQL and Formspider

Advanced Data Grid Features in Formspider. The Tutorial: The Demo:

Paging Data Grid with zero lines of PL/SQL in Formspider

Some frameworks come with built-in paging buttons in their grids that you cannot customize. This limits a developers ability to design UI's the way he/she wants. Some frameworks have the API's for paging and developers have to do the rest themselves.

In Formspider, we have best of the both worlds. You can build your own paging implementation using Formspider paging API's or you can use Formspider paging components and implement paging in your data grids with no coding. However Formspider paging components are independent of the grid. You can place these components anywhere you want on the screen. So you still have the flexibility to design your UI the way you want. Click here for the short tutorial.

Three Levels Deep Master Detail Screen with PL/SQL and Formspider

When I was in Netherlands, attending the Future of Forms event at the Amis office, the number one thing everyone asked me was whether Formspider supports building three level deep master detail screens (an MDD screen). Apparently,  it is very annoying to build an MDD screen with Apex. In one of the sessions, the presenter praised ADF because it allowed developers build such screens. She said seeing an MDD screen work was the defining moment for her in becoming an ADF convert.

The whole ordeal was shocking to me. With Formspider, we took building an MDD screen as such a matter of course, we did not even bother putting up a demo on our web site.

After the Future of Forms event, we thought it would be a good idea to actually save the five minutes and build an MDD demo application. So without further ado, here is a three levels deep master-detail-detail application built with PL/SQL and Formspider. Click here to see it.

I hope this will be enough to convert the presenter back to PL/SQL.