Introduction
Flexqueries project is a development framework for Flex and Php. It allows us to write database web apps as if we wrote a classic desktop application. SQL is written client-side, datasets are local.
Data classes:
- SqlQuery :it’s the query executor, mixed with a dataset. It allows execution of any query, synchronously or asynchronously. In case of a Select statement, it provides methods to loop through retrieved data (dataset functionalities).
- SqlUpdater : Linked to a SqlQuery, it applies to the database the modifications done in the Sqlquery’s dataset.
- SqlDataGrid : Visual grid, linked to a SqlQuery. It can edit, add or delete rows from the local dataset (SqlQuery). Modifications are then applied by the SqlUpdater.
- SqlComboBox : Combobox, linked to a SqlQuery
- SqlEvents : SqlQuery relative events
- SqlTransaction : Can be used to manage transactions. You prepare the queries to execute in the transaction and run executeAsync() or executeSync() to run it. Commit and rollback are automatically performed server-side.