Results 1 to 10 of 63

Thread: RELEASE! The Database Update Framework is released today.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #4
    Join Date
    Feb 2009
    Location
    Goteborg, Sweden
    Posts
    3,189

    Default Version 1.0.0.19 available! The Database Update Framework.

    To All;

    An update has been published for the Database Update Framework.

    Version 1.0.0.19 can be downloaded here.

    Here's what's new:

    Version: 1.0.0.19 Date: 2017-07-26

    - A parameter bug in SqlColumnAdd and SqlColumnAddByTableName was fixed. All parameters after the third should be optional to pass. However, the function code was wrong and has been corrected.
    Reported by Nils Svedmyr

    - A bug was discovered when converting between framework defined data types and DataFlex data types. In short; there are replacement data constants to be used with the framework when dealing with an SQL back-end. See the help chapter “DataFlex Replacement Data Types” for a full explanation. These framework datatypes has the same integer number as the standard DataFlex data types, but with the value -1500 deducted. This is to distinguish them from specialized SQL driver data type constants (there were duplicates). However, the framework conversion logic had it slightly wrong which made the data type conversion to fail. Note: The recommended way to use e.g. the SqlColumnAdd function is to pass one of the specialized data constants. What that constant is depends on the driver used, the database back-end type and the exact column type that is targeted.
    Reported by Nils Svedmyr

    Improvements:
    - The ApiColumnAdd function was improved to take on two more parameter that makes it possible to initialize the new column with a value. This is in parallel with how the SQL counterpart function SqlColumnAdd works. In fact when doing this work it became obvious it might be a good idea to break out the functionality that updates the column value to its own function, as that can come in handy in other cases as well. The new function created is named ApiColumnUpdateValue. When creating this new functionality the old SqlColumnAdd function was split in two and the update logic was moved to the new function SqlColumnUpdateValue. You can read more about this in the on-line help.
    ​Suggested by Sam Neuner
    Last edited by Nils G. Svedmyr; 27-Jul-2017 at 08:30 AM. Reason: wording
    Nils Svedmyr
    RDC Tools International
    www.rdctools.com

    "The problem with internet quotes is that you don't know if they are true."
    Abraham Lincoln

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •