HEA Apprentice

  • Member since Apr 29th 2021
  • Last Activity:
Profile Hits
79
  • hallo hab dir den Post von mirecko weitergeleitet ...

    new conversation for new version - SQL


    jericho found a issue on deploy31, i cant replicate it on my dev pc, neither on my 2nd pc.

    anyway deploy31 had an issue with updating basic prices for commodities, it did do only first 20 of them.

    i had to use other way of navigation through the commodities table.


    it is fixed in deploy 311


    edit:

    there was an error on my side, no username 4 the database caused it to try to use it with 'currentwindowsuser'

    now its hardcoded , so should be working

    link is fixed to deploy312


    edit 2:

    after feedback from Jericho, who is unable to run the app - some issue related to SQL acces to tables, I added some more detailed logging at startup

    so new deploy, with todays data

    link is fixed to deploy313



    link:

    https://drive.google.com/file/d/18pxy-eys3fbvedr7x_b1amb9dx6htxpc/view?usp=drive_link


    so unzip the archive, any folder you want,

    get the CF path.txt from older working folder, or edit the path to your CF directory, make sure time value in next line is your local server restart time.

    run the

    CFCommoToolSQL.exe


    see if it works


    pls let me know how it works

    thanx


    Mirecko