Welcome to the Axosoft Community, Sign in | Register | Help
in Search

Using stored procedures for lookups...

Last post 09-14-2007, 7:36 AM by Dan Suceava. 1 replies.
Sort Posts: Previous Next
  •  09-12-2007, 10:20 AM 13151

    Using stored procedures for lookups...

    Is there a way that an input can be provided for a lookup-type custom field. More specifically, can the input be a value that is associated with a static field for the current record. For instance, if I create a new table in the OnTime DB that has a 'defect ID' column to relate each record to a specific defect, can I then get access to that record when it is loaded in order to pass the defect ID value to a stored procedure that populates a lookup on the form in which that defect is opened?

     If not, that would be a great feature to expand the capablities of using stored procedures for lookups.



    Chris
    First rule of leadership...everything is your fault.- Hopper

     

  •  09-14-2007, 7:36 AM 13175 in reply to 13151

    Re: Using stored procedures for lookups...
    Currently that is not possible, there is no way to pass in the defect id to the sproc that the pick list custom field is based on.  I've added this as a new request into our system.
    Dan Suceava
    http://www.axosoft.com
View as RSS news feed in XML

© 2002 - 2007, Axosoft, LLC. All Rights Reserved. | Privacy
Bug Tracking | Defect Tracking Videos | Help Desk Software