Page 6 of 6 FirstFirst ... 3456
Results 51 to 56 of 56

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

  1. #51
    Join Date
    Feb 2009
    Location
    Goteborg, Sweden
    Posts
    2,949

    Default Re: RELEASE! The Database Update Framework is released today.

    RE: 1) You are right that the Boolean value had been reversed. So it should have been "If (bExists = False) Begin"...

    RE: 2) Yup, there was actually a couple of bugs that I now have corrected in the ApiColumnChange. Probably happened somewhere along the update to version 2 of the framework.

    The correct syntax to use should be:

    "Get ApiColumnChange MyTable.File_Number "MY_FIELD" DF_BCD_DUF 10 6 to bOK"

    I will email you the corrected cDbUpdateFunctionLibrary.pkg file.

    Thanks for the report!
    Nils Svedmyr
    RDC Tools International
    www.rdctools.com

    "Politics is the art of looking for trouble, finding it everywhere, diagnosing it incorrectly and applying the wrong remedies."
    Groucho Marx

  2. #52
    Join Date
    Feb 2009
    Posts
    770

    Default Re: RELEASE! The Database Update Framework is released today.

    Hi Nils,

    Ok, I got it working now, the glitches that I was seeing when changing fields have gone.

    One note.
    When you add a column, and you need that it stores 4 digits and 4 decimals you do something like this:
    Code:
    Move (bOk and ApiColumnAdd(ghoDbUpdateFunctionLibrary, hTable, "MY_FIELD", DF_BCD , 4, 4, False, "")) to bOk // SQL = numeric(8, 4)
    When you need to change a column to store 4 digits and 4 decimals you have to do something like this:
    Code:
    Move (bOk and ApiColumnChange(ghoDbUpdateFunctionLibrary, hTable, "MY_FIELD", DF_BCD , 8, 4)) to bOk // SQL = numeric(8, 4)
    Do you think it is an acceptable inconsistency?

    Regards.
    I know, I have to learn a lot of things (english the first thing...)

  3. #53
    Join Date
    Feb 2009
    Location
    Goteborg, Sweden
    Posts
    2,949

    Default Re: RELEASE! The Database Update Framework is released today.

    You are correct Jose, that is a "glitch". I will fix this inconsistency.
    Nils Svedmyr
    RDC Tools International
    www.rdctools.com

    "Politics is the art of looking for trouble, finding it everywhere, diagnosing it incorrectly and applying the wrong remedies."
    Groucho Marx

  4. #54
    Join Date
    Feb 2009
    Posts
    770

    Default Re: RELEASE! The Database Update Framework is released today.

    Hello Nils,

    Last pkg have solved the inconsistency.

    Regards.
    I know, I have to learn a lot of things (english the first thing...)

  5. #55
    Join Date
    Oct 2014
    Location
    Heerlen, NL
    Posts
    214

    Default Re: RELEASE! The Database Update Framework is released today.

    Quote Originally Posted by Nils G. Svedmyr View Post
    Right, I think I understand your setup. I have to think about this a bit as - just as you already figured - DUF was not designed for this kind of setup. However, it should still be possible to do what you want/need but I need to give it some thought and get back to you.
    Hello Nils,

    Have you had time enough to give me a answer? DUF works like a charm, I generated the update code from my database and can create a filelist and the complete database from scratch. I would also like to be able to create these tables when creating a new account with dataflex tables. Currently I am rewriting my code to get rid of a lot of old (<1995) code and replace obsolete controls to make it work in future editions.

    Regards,

    Leon Raafs

  6. #56
    Join Date
    Feb 2009
    Location
    Goteborg, Sweden
    Posts
    2,949

    Default Re: RELEASE! The Database Update Framework is released today.

    Hi Leon,

    I send you a private email.
    Nils Svedmyr
    RDC Tools International
    www.rdctools.com

    "Politics is the art of looking for trouble, finding it everywhere, diagnosing it incorrectly and applying the wrong remedies."
    Groucho Marx

Posting Permissions

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