Softpedia >Windows >Internet >Servers >Database Utils >MS SQL PHP Generator Professional >  Changelog

MS SQL PHP Generator Professional Changelog

What's new in MS SQL PHP Generator Professional 12.8.0.18

Jul 23, 2014
  • Ability to specify several output paths for a project is added (useful if you want to test the generated app under several local webservers).
  • Now it is possible to include/exclude all columns to/from a certain presentation with a single click.
  • Editors for entering file name templates (for example, in the Upload file to folder properties dialog) become more convenient.
  • MS SQL: default content encoding is set to ANSI.
  • Some client-side events did not fire for Insert forms in master/detail pages.
  • Changes of column properties at the General tab could be displayed incorrectly for columns excluded from the List view.
  • Headers of "Stored value" and "Display value" columns in Radio/Checkbox group editors are not swapped anymore.
  • Popup hints for "More" links become available for columns of detail rows in master/detail views.
  • Popup hints for "More" links could be displayed for non-english texts even if the text is not truncated.
  • Images stored in the database could be displayed incorrectly in master/detail views if columns in master and detail tables have the same name.
  • Uploading images to the database could cause a PHP warning in the strict mode.
  • MS SQL: national symbols are now inserted and updated correctly even if the database collation does not correspond to the system locale.
  • Code generation from the command line did not work without specifying the -o parameter (output directory). Now this parameter is not required (as it can be obtained from the project file).
  • Some other minor fixes and corrections.

New in MS SQL PHP Generator Professional 12.8.0.16 (Apr 8, 2014)

  • Support for user-defined parameters in custom templates. More information and examples.
  • Ability to use separate custom layout templates for Insert and Edit forms.
  • MS SQL Server: added support for SQL Server Express LocalDB databases. To access such databases, use SQL Server 2012 Native Client (SQLNCLI11) and SQL Server Driver for PHP.
  • Czech localization has been improved. Thanks to Jaromír Adámek.
  • Hopefully the final fix for processing datetime values in formats like m-d-y or d/m/Y. Now should work correctly for all supported versions of PHP.
  • Filter row: filtering on date/datetime values could cause an error.
  • Export to some formats could work incorrectly on using the ANSI encoding.
  • Some other minor fixes and code optimization.

New in MS SQL PHP Generator Professional 12.8.0.15 (Feb 24, 2014)

  • A new implementation of HTTP tunnel based on the MySQLi PHP extension.
  • Smart default values of view/edit properties for pages based on queries.
  • Automatic detection of query key columns.
  • The visible (true|false) method added to the editor's API.
  • A modal editor for lookup conditions becomes available (useful for lengthy and complex conditions).
  • A link to the manual is included into the warning on invalid queries.
  • Less compiler errors (if any) are now dispalyed in the preview window after theme customization.
  • A warning message is displayed in the preview window on detecting an obsolete IE version
  • Command buttons are added to the Details tab of the Page Editor.
  • "More information and examples" link becomes available for global events.
  • Combobox editor could display incorrect value if detail field contains NULL and master table contains a record with id = 0.
  • Datetime values could be processed incorrectly on using some datetime formats like m-d-y or d/m/Y.
  • A warning message is displayed if either .NET framework or dotLess compiler are missing in the system.
  • A missing ampersand is added to the customHTMLHeaderText parameter in the OnCustomHTMLHeader event handler.
  • Some other minor fixes and code optimization.

New in MS SQL PHP Generator Professional 12.8.0.14 (Nov 22, 2013)

  • Filter row: the "Apply filter automatically" option is added. Also it becomes possible to specify the timer interval .
  • Default empty grid height was decreased from 200 to 25 pixels.
  • The login panel is now always visible and right-aligned (even on pages with a large amount of columns).
  • There are no more conflicts between the library and generated files (so it becomes possible to use any file names for output pages).
  • User-defined styles are now applied to the login page.
  • Some markup corrections to simplify applying of user-defined styles.
  • A number of translations have been updated.
  • Some other minor fixes and code optimization.

New in MS SQL PHP Generator Professional 12.8.0.12 (Sep 2, 2013)

  • This version has been successfully tested with PHP 5.5.
  • Support for the SQLite3 database extension has been implemented.
  • MySQL bit(1) columns are now displayed as check boxes.
  • Turkish localization has been added.
  • Fixed some potential security vulnerabilities.
  • PostgreSQL: modal and inline inserts could work incorrectly on using the serial data type.
  • Some other minor fixes and code optimization.

New in MS SQL PHP Generator Professional 12.8.0.11 (Jun 20, 2013)

  • Support for keyboard interactive SSH authentication has been added (when applicable).
  • New program icons designed for up to 256x256 resolution.
  • Now end-users can change their passwords themselves (on using table-based authorization).
  • Record-level security becomes available for the first level detail pages.
  • Admin panel: now to change a user password you need to enter it twice to avoid input mistakes.
  • The inline display mode has been added for checkbox and radio groups (default mode is stacked).
  • A handy editor has been added for editing combobox and radiogroup values.
  • Computed columns are now excluded from the edit and insert forms by default (where applicable).
  • Slovenian localization has been added. Thanks to Marko Bratkovic.
  • No warnings are displayed anymore on opening the generated PHP files in our favorite IDE.
  • Record-level security: additional verification of permissions has been added on opening of edit forms and on saving data.
  • Table-based authorization: application and page-level permissions could be incorrectly saved in the database in certain cases.
  • Now all the SpinEdit properties are saved, restored, and processed as expected.
  • Some other minor fixes and code optimization.

New in MS SQL PHP Generator Professional 12.8.0.10 (May 23, 2013)

  • New modern look and feel. The main goal of the new version is to provide a capability to construct a modern-look and powerful web applications in the simplest possible way. For this purpose we significantly changed the design for all generated pages and refactored the web code. We hope you and your end-users will like the new UI. As usual, all the new features can be seen in action in our demo application.
  • Enhanced master-detail management. The new version provides some extremely useful features such as inline displaying of nested detail views without limitation on the depth and displaying several detail presentations simultaneously on the tabs.
  • Custom templates. From now on you can customize the design and layout of pages produced by PHP Generator according to your needs. For example, you can change captions, re-arrange controls, or even add a chart diagram for a certain page.
  • Automatic Filter Row. This row is displayed at the top of the data rows and allows you to filter data on the fly by typing text directly into the row. When you type the text within a cell in the row, a filter condition is automatically created based upon the values entered and applied to the column. The filter is updated automatically after 1 second after entering a value or when you press the Enter key.
  • Filter Builder. This control displays filter criteria as a tree structure and allows you to visually build complex filter criteria with an unlimited number of filter conditions combined by logical operators. The Filter Builder window can be invoked by pressing the Create filter link at the bottom of the grid.
  • New visual themes. In this case a picture is worth a thousand words, so please find all of them at the appropriate step of the software.
  • Improved usability. Starting from this version you can access detail pages directly from insert, edit, and view forms. This should be especially useful on adding new records.
  • New Autocomplete and Milti-Level Autocomplete controls. The new versions of these widgets allow you to select a required value as comfortable as possible.
  • New "after action" events. The OnAfterInsertRecord, OnAfterEditRecord, and OnAfterDeleteRecord events are now at your disposal.
  • On-the-fly metadata refreshing. Starting from this version you can synchronize your database schema changes with PHP Generator in a single click.

New in MS SQL PHP Generator Professional 11.12.0.1 (Dec 23, 2011)

  • Security enhancements. One of the most important features implemented in this version is a possibility of storing user permissions in a database table. This allows you to manage them without re-generation of the scripts using the special Administration Panel (available only for users with the admin permission).
  • Powerful data export features. New version provides a completely new PDF export engine with Unicode support and great customization abilities. Also we have added the OnCustomRenderExportColumn event to adjust the output data according to your needs.
  • New insertion and editing modes. Starting with this version the Save button in the Insert Record form allows you to post changes to the database and re-open the form for adding another record in a single click (without returning to the List page). Another useful thing is a possibility of continue editing of the record after posting the changes in both Edit and Insert forms.
  • Advanced control management in Edit and Insert forms. From now on you can use new OnInsertFormControlValueChanged and OnEditFormControlValueChanged events to manipulate with form controls. For example, you can enable/disable a certain control or fill a combo box depending on a value entered in another control.
  • Improved project management. Starting with this version PHP Generator allows you to save previously opened project without entering a file name with the Save command. To save the project to a new location, use the Save As command.
  • Copying and viewing data in modal windows. From now on you can view and copy individual records without opening a separate webpage. The corresponding abilities can be activated for a whole project or for a concrete page.
  • Lookup filtering. Now it becomes possible to filter the contents of lookup controls. Moreover, all the supported variables are accessible in the filter condition.
  • Command line generator. Did you know that PHP Generator can build ready-to-use web application even without running the UI? Automate your work with a few mouse clicks. The result command line can be copied to Clipboard or saved to a batch file.
  • Bug report sender. Found an occasional bug? Even sending a bug report becomes a pleasure with the new version.
  • Speeded up schema refreshing. We have improved the algorithm of the metadata refreshing to save a few moments of your valuable time.

New in MS SQL PHP Generator Professional 11.4.0.4 (Nov 18, 2011)

  • Support for multi-level auto-complete editors.
  • Edit and insert data within modal dialogs.
  • Use a fixed header for data grid as well as display line numbers for grid records.
  • Client side validation has been significantly improved.
  • Time edit control and masked edit control that provides restricted data input.
  • Support for grid footers.
  • Excluding certain files from the output.
  • Enable lookup editors based on a template that contains one or more table columns.
  • The Generate thumbnail option.