Home Blogs jose P1427Delphi for PHP next release, early preview #14 - Data Explorer

Delphi for PHP next release, early preview #14 - Data Explorer

Posted by jose P1427 on Thursday, 27 May 2010 in Blogs

Note: If you want to be updated on Delphi for PHP, you can follow me on twitter http://twitter.com/qadram, and you can see what's going on by checking the brainstorm site http://brainstorm.qadram.com/, more details about the brainstorm site here.

In this video, I show you how the new Data Explorer works, featuring support for Firebird inside the IDE and the new Visual Query Builder.

You will see how to add a new connection, the new advanced connection properties dialog, which elements you can explore, etc. Also shows how to retrieve data from table, which is open on the IDE as a module, and how you can modify the data and even perform commit and rollback operations.

To demonstrate the SQL Window, you will see how to develop an SQL sentence visually, just by dragging and dropping. Now, .sql files have a new "Design" tab, to allow you modify the query visually, and you will see how .sql files can be linked to a connection on Data Explorer.

Finally, you will see how to drag and drop database elements to a form, and even, how to use the Visual Query Builder to setup a query.