Database Binding

The designer user can bind data controls with backend databases. You can use one of three ways to bind

o        Select table-column from a drop-down

o        Visually build your SQL from a GUI. The SQL can have nested queries , Where clauses , Group By and Order By Clauses

o        Directly enter the SQL in the box provided, manually.

You can bind different data-sources for reading from the database and writing back to the database, providing flexibility at every step. At the moment, Microsoft SQL server, Oracle and MySQL are supported. Stored procedures are supported for MS SQL Server.