in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
InaPlex Forums » Product Forums » Inaport » slxgetpickid function on returning ITEMID in latest version of Inaport (v7.0.7312)

slxgetpickid function on returning ITEMID in latest version of Inaport (v7.0.7312)

Last post 01-21-2008 19:52 by admin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 01-19-2008 2:46

    • fyung
    • Top 75 Contributor
    • Joined on 01-19-2008
    • Posts 1

    slxgetpickid function on returning ITEMID in latest version of Inaport (v7.0.7312)

    Reply Contact

    When I compose this expression slxgetpickid('k6UJ9A000020', #Pulldown2) as a new field, the test returns 0 which is the value of ID column of the SalesLogix PICKLIST table.  However, ID column is not a uniquekey column and that is not its documented functionality.

    I had to write this to get the proper ITEMID back and this requires the PRO version:

    dbexecsql("T", "SELECT ITEMID FROM PICKLIST WHERE TEXT = '" & #Pulldown2 & "' AND PICKLISTID = 'k6UJ9A000020' ")

    We have not made the purchase but this is a pretty serious bug in your system.  Can you please check?

    Thanks.

  • 01-21-2008 19:52 In reply to

    Re: slxgetpickid function on returning ITEMID in latest version of Inaport (v7.0.7312)

    Reply Contact

    Hi Fred

    We have confirmed this problem, and it has been fixed in build 7.0.8021.

    This build is not avaialbe on the web site yet, but can be supplied if required.

    Regards

    David
Page 1 of 1 (2 items)
InaPlex Limited 2011