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

Browse by Tags

All Tags » Stored Procedures   (RSS)
  • Modifying Existing SP and save as new SP

    Hello... The current Work Log report is does not have some of the fields that we would like to have on the report.  Is it possible someone can help me modify spS_WorkLog_WithNames stored procedure.  I would like to add field from DefectCustomFields.Custom_121 if ItemType = DefectFeatureCustom_Fields.Custom_123 if ItemType = ...
    Posted to OnTime General (Forum) by dkhatri on February 7, 2008
  • Re: RE: Editing Picklists with Stored Procedures

    Hi, Is this fixed in the 2008 build? Thanks, JP. 
    Posted to OnTime General (Forum) by John-Paul on December 2, 2007
  • 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 ...
    Posted to OnTime General (Forum) by DynoEnviro on September 12, 2007
  • Invalid SQL Syntax

    I have a stored procedure called 'spD_DefectsByStateAndSeverity' which is defined as follows: CREATE PROCEDURE [dbo].[spD_DefectsByStateAndSeverity](    @ProjectID int = NULL)ASSELECT * FROM Defects  When I try to create a custom report and enter the following SQL Command: spD_DefectsByStateAndSeverity @ProjectID = 437 I ...
    Posted to OnTime General (Forum) by nguiffrida on September 4, 2007

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