1 Reply Latest reply on Apr 20, 2009 11:12 AM by philmodjunk

    Developer Advice



      Developer Advice


      I am finishing a governmental application that requires a change in certain figures every 6 months.  I debated what was the best way provide for the change of numbers to the client.  I could have gone with a table or with a script.  The script is the better way to go but it will require a patch being sent out every 6 months.


      Can anyone give me direction on how best to provide this patch?  Essentially I would like to send a small patch that changes nothing other than that one script.  I've developed a script that will address al the changes and dates without affecting older files that may need to stay the way they were with the older numbers for that aprticualr application.


      The script is a series of about 15 SET FIELD statements.


      Can I supply just a patch to the program or do I need to send out a whole aplication with a import script?


      Thank you.


      Using FM 10

        • 1. Re: Developer Advice

          I can't tell for sure without knowing more about your database, but this sounds like a change that should NOT be done with the script patch you describe. With the right table design, you can send users a new table/file for update that will affect all new records without changing the numbers for existing tables. We do this type of update all the time where I am whenever we change the prices we pay for items customers bring in for recycling.