Announcement

Collapse
No announcement yet.

Product Reference Field Bug

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Product Reference Field Bug

    New bug - and it features duplicates!

    My understanding is this:

    The product reference field in Actinic is limited to 20 characters. I have switched from "auto generated product references" to manual references so I can implement the Quickbooks Link. I then typed in long text product references.

    However, after I did this I got a error on startup saying "Data Truncated". It would seem that the 20 characters is fine for parent products but when a duplicate is created Actinic appends a number and an exclamation mark to the front of the product reference field. If the Product reference field length is already 19 or 20 characters long then these extra 2 characters will make the duplicate product reference too long for Actinic to start.

    eg.
    Parent product ref = Viper Classic Repair (20 characters)
    Duplicate = 1!Viper Classic Repair (22 chars)
    Result: Actinic cannot start.

    Actinic tech support said this is a bug in Actinic.

    Solution is to manually open the Product table in Access and make the text field length 20 chars. The data will then load but the duplicates will no longer work and will need deleting and recreating.

    Prevention? Well I guess I need to remember not to make the product reference fields longer than 18 characters. I guess you could set the Product Reference Character Count field length in Actinic to 18???

    Thought some of you might want to know about this.
    Pete

    www.Euro-Yo.com Europe's largest online yo-yo shop
    www.LetsHaveFun.biz for skill toys
    www.Euro-rang.com specialist boomerang store
    www.Kendama-World.com for Japanese Kendama

    A heart transplant at Papworth Hospital in February 2005 saved my life. Please consider signing up on the Organ Donor Register at www.uktransplant.org. Give Life!

    #2
    Good advice Peter, i'd probably even go the extra mile and say 17 chars, so duplicates of over 9 instances are also OK.

    Comment


      #3
      Wow that is a lot of duplicates but good point Lee!
      Pete

      www.Euro-Yo.com Europe's largest online yo-yo shop
      www.LetsHaveFun.biz for skill toys
      www.Euro-rang.com specialist boomerang store
      www.Kendama-World.com for Japanese Kendama

      A heart transplant at Papworth Hospital in February 2005 saved my life. Please consider signing up on the Organ Donor Register at www.uktransplant.org. Give Life!

      Comment

      Working...
      X