Softpedia >Windows >Internet >Servers >Database Utils >SQLite PHP Generator Professional >  Changelog

SQLite PHP Generator Professional Changelog

What's new in SQLite PHP Generator Professional 12.8.0.18

Jul 23, 2014
  • New! Barcode Symbologies added:
  • Han Xin Code (2D) Chinese Barcode
  • GS1 QR Code
  • IFA PPN (securPharm) 2D Data Matrix with PZN8 auto conversion
  • HIBC LIC 2D Data Matrix, QR Code & Aztec Code versions
  • HIBC PAS 2D Data Matrix, QR Code & Aztec Code versions
  • ISBT 128 2D Data Matrix
  • Deutsche Post Response Plus PostMatrix 2D
  • USPS Intelligent Mail Package Barcode IMpb
  • EAN-14 (GTIN-14)
  • DUN-14 (ITF and GS1/EAN/UCC Versions)
  • DHL AWB Code 39
  • Deutsche Post BZL Code 128
  • New! EAN/UPC Magnification Factor setting
  • New! String Format Patterns are supported for Code & Text properties
  • New! SnapsToDevicePixels property which allows pixel perfect rendering on the target device canvas
  • New! ITF-14 H Marks (Print Gain Gauge)
  • New! Get the runtime value for Auto-type properties when a barcode symbol is generated. Mainly found in 2D symbologies.
  • New! Create artistic barcode symbols by specifying a custom image pattern to fill the bars & dots (ArtBarImagePattern property) as well as stamping logos (ArtLogoImage) with opacity option!
  • New! For WebForms
  • Now the barcode image can be rendered as an embedded image using Data URI feature supported by most modern browsers.
  • A new parameter was added to the Codeless Barcode Generation feature to allow encoding non-printable chars through Base64 encoding
  • ErrorBehavior property that determine what our product will produce if an error occurs when generating the barcode image like generate a Blank Image, An Image displaying the Error Message, or Throws an Exception.
  • New! For MVC
  • A brand new Barcode dll exclusively designed for ASP.NET MVC that supports all MVC versions, allows you to embed barcode images into Views as well as the flexibility to create barcodes images in any Controllers
  • Improved! GS1-128 (formerly EAN/UCC-128) Application Identifiers updated per GS1 General Specification v13
  • Improved! HIBC LIC updated to Spec. v2.3 SLS (2009)
  • Improved! HIBC PAS updated to Spec. v1.3 (2010)
  • Improved! ISBT 128 updated to Spec. v4.5.0 (2013)
  • Improved! Error handling in the overall Barcode generation process. New BarcodeException class with some standard error codes and descriptions.
  • Improved! In 2D barcodes with Auto Format or Version selection options, now user selected fixed value is honored and an exception will be thrown if data to encode exceeds it. In earlier versions, the behavior was to auto select a new format or version if possible. The 2D Symbologies affected are: Aztec Code, Data Matrix, MicroPDF417, QR Code, and Micro QR Code.

New in SQLite PHP Generator Professional 12.8.0.16 (Apr 16, 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 SQLite PHP Generator Professional 12.8.0.15 (Feb 27, 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 SQLite 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 SQLite PHP Generator Professional 12.8.0.12 (Sep 3, 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 SQLite PHP Generator Professional 12.8.0.11 (Jun 17, 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 SQLite PHP Generator Professional 12.8.0.10 (Jun 17, 2013)

  • The "Set null" checkboxes are not displayed anymore by default.
  • The "Define key columns" button is no more available for invalid queries.
  • Non-English symbols are now displayed correctly when using as True Caption / False Caption for columns with View Properties = Checkbox.
  • MS SQL Server: non-English symbols are now displayed correctly within inline details.
  • The OnCustomRenderTotals event handler code was not saved in the project file for detail pages.
  • A warning message could be displayed in certain cases when there are no columns in the filter row.
  • The extra stars for read-only columns are no more displayed in the Edit/Insert forms.
  • The column captions containing the apostrophe (') could cause some errors in the JavaScript code.
  • An informative message is displayed now when trying to access Admin Panel without the appropriate permissions.
  • Combobox-style partitions makeup has been slightly improved.

New in SQLite PHP Generator Professional 12.8.0.9 (Jun 17, 2013)

  • Page titles and menu labels for detail pages can be edited now directly in the Page List.
  • Page Navigator is improved to help users to estimate number of records in the data set.
  • Admin panel: the "Page name" column now displays menu labels instead of object names (e.g. Customers.Orders instead of tbl_customer.tbl_order).
  • Now it is possible to reset quick filter by entering an empty string and pressing Enter.
  • Passwords are now stored and transferred encrypted everywhere.
  • The comparison operators like =, >=,

New in SQLite PHP Generator Professional 12.8.0.8 (Jun 17, 2013)

  • Menu labels become accessible directly from Page List.
  • Support for passwords encrypted with crypt() and hash() functions (all algorithms) is added.
  • Key columns for views are now stored fine in the project file.
  • PostgreSQL: record-level security might work incorrectly in certain cases.
  • Filter Row did not accept values containing single quotes.
  • Filter Row enability for a page could be stored incorrectly in some cases.
  • Admin page now includes user-defined styles.
  • "Only variables should be passed by reference..." warning message could be displayed on accessing Admin Page.
  • Filter Builder now displays column captions instead of field names.
  • A string constant for NULL values is added to localization files. Some other strings are added there too.
  • The "Open search page at first" option is now processed correctly.
  • The "Force download" option for "File download" columns now works fine.
  • Columns excluded from the List view did not appear in Filter Builder too independently of the appropriate option.
  • Page Editor: the "Advanced search" column is finally renamed to "Filter builder".
  • Page Editor: the "Quick search" tab was removed as it did not contain any valuable options.
  • Aliases for generated lookup queries are now quoted if necessary.

New in SQLite PHP Generator Professional 12.8.0.7 (Jun 17, 2013)

  • The OnCustomRenderColumn event did not fire for newly added records in the inline mode.
  • Inline insert/edit: an error message on loading too large pictures was displayed even after pressing Cancel.
  • Loaded pictures are now displayed correctly on editing a record in the inline mode.
  • Data from HTML WYSIWYG are now saved fine in the database in all edit/insert modes.
  • Multi-level autocomplete editor could work incorrectly in the inline mode.
  • Multi-level autocomplete editor now works fine even if the database contains no foreign key constraints.
  • Non-English texts rendered with $this->RenderText() in OnCustomRenderColumn event handlers are now displayed correctly on viewing a record.
  • Custom templates did not apply for modal editors.
  • Page navigators were displayed incorrectly in certain cases
  • Radio buttons looked ugly in some color schemes.
  • The resource image was missing for the External File option.
  • ComboBox editor is now displayed correctly in the inline mode.
  • OnEditFormEditorValueChanged/OnInsertFormEditorValueChanged events did not fire for radio buttons.
  • The Copy button was displayed even if a user has no Insert privilege.
  • The "Use general options" checkbox did not disable certain controls.
  • A detailed description of multi-level autocomplete editor is added to the manual

New in SQLite PHP Generator Professional 12.8.0.6 (Jun 17, 2013)

  • A special build to fix the problem with editing date and datetime values on using custom formats.

New in SQLite PHP Generator Professional 12.8.0.5 (Jun 17, 2013)

  • The "Show page list" option now has 3 possible values (Show expanded, Show collapsed, and Disabled)
  • Brazilian and Serbian translations are added
  • The rowData array in the OnAfterInsertRecord event now contains values of autoincrement columns
  • Row Level Security now works fine for queries that contain spaces in their names
  • The First day of Week option now applied correctly for date and datetime controls
  • Application level permissions could not apply correctly on storing permissions in the database
  • The list of available variables is displayed if SHOW_VARIABLES is turned ON
  • Right-to-left text direction is supported again
  • Oracle: in some cases data was not inserted or updated
  • Oracle: date values could be displayed incorrectly
  • Scrolling bars are now displayed correctly in modal forms
  • Number of connections opened by PHP Generator has been reduced
  • Missed strings are added to the appropriate language files
  • The default ordering now applied to inline master-detail views
  • CHAR and DECIMAL columns become orderable
  • SQLite: pagination works correctly for pages based on queries
  • Custom partitions are now displayed correctly even if pagination is disabled
  • Expanded inline details were not hidden on deleting the master record
  • The "No records to display" message was not displayed on deleting the last record from the grid
  • Pagination hints could be displayed in an incorrect encoding

New in SQLite PHP Generator Professional 12.8.0.4 (Jun 17, 2013)

  • Adding data to the detail pages via modal dialogs becomes possible.
  • Database server based authorization might not work properly.
  • Query-based lookups work fine now.

New in SQLite PHP Generator Professional 12.8.0.3 (Jun 17, 2013)

  • The "Force download" option for opening files from BLOB columns.
  • An ability of adding custom CSS to the project.
  • Current user name and ID become accessible in custom templates (as {$Authentication.CurrentUser.Name} and {$Authentication.CurrentUser.Id}).
  • Links to non-installed PHP drivers are included into the appropriate error messages.
  • Correct order of days of weeks in DateTimePicker control.
  • Values of radio button controls come correctly to client-side event handlers.
  • Headers are displayed in correct color for the SuperHero theme.
  • Missed strings are added to language files.
  • The OnCustomHTMLHeader event now fires correctly.
  • OnCustomRenderColumn event now fires for single record view.
  • Highlighting search results on using Quick Filter.
  • mysql_escape_string function is not used anymore to prevent warnings.
  • Date/Time editor can be displayed incorrectly in the inline mode, modal windows, and Filter Builder.
  • OnEditFormValidate event fired on validating insert forms.
  • Passwords containing the ";" symbol are allowed now.

New in SQLite PHP Generator Professional 12.8.0.2 (Jun 17, 2013)

  • Some small fixes.

New in SQLite PHP Generator Professional 11.12.0.8 (Jun 17, 2013)

  • Default Format for Edit Properties in date/time editors.
  • Polish and Hungarian translations.
  • Validators string resources become localizable.
  • Default values for detail pages can be applied incorrectly.
  • Permissions are applied correctly for queries containg spaces in their names.

New in SQLite PHP Generator Professional 11.12.0.7 (Jun 17, 2013)

  • It becomes possible to use environment variable in filters.
  • "More information and examples" links added to event editors.
  • The Max Length value is set according to column length (e.g. 10 for varhcar(10)).
  • Validation messages can be displayed incorrectly in some cases.
  • Currency symbol can be displayed incorrectly on using the UTF-8 encoding.
  • Detail links are now displayed correctly on inline editing.
  • Editors for columns with XML data type now allow HTML by default.

New in SQLite PHP Generator Professional 11.12.0.6 (Jun 17, 2013)

  • Some strange symbols could appear on shortening long text.
  • Page captions might be displayed incorrectly in the admin panel.
  • Viewing in modal dialog was allowed only if a user has an UPDATE privilege.
  • Thumbnails are displayed correctly even if the imageantialias PHP function is not available.
  • Custom attributes for Edit Properties were not taken into consideration.
  • Current partition is restored correctly after the record editing.
  • The character encoding for the login page and admin panel was not specified explicitly.
  • Different radio buttons could have the same id attribute.
  • Aggregates for pages based on a query might be calculated incorrectly.
  • Default values for string columns are now displayed well.
  • OnInsertFormEditorValueChanged/OnEditFormEditorValueChanged event handlers were ignored for MultiLevelAutoComplete controls.
  • Data export engine ignored the selected partition (always exported data from the first partition).
  • Thumbnails could be stored incorrectly on saving BLOBs.

New in SQLite PHP Generator Professional 11.12.0.2 (Jun 17, 2013)

  • Some small fixes.

New in SQLite 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.