Grid Values won't delete if populated by Stored Procedure

A forum for User Initated & Scheduled Workflows
cskantzaris
Posts: 23
Joined: Thu May 29, 2008 2:03 pm
Deltek Vision Version: 4.1
Number of Employees: 150
Company Position: Enterprise Application Manager
Vision Modules: Own full suite, rolling our Resource & Project Planning Q4 this year
Number of Offices: 0
Year Vision Installed: 2005

Grid Values won't delete if populated by Stored Procedure

Postby cskantzaris » Thu Oct 15, 2009 10:01 am

I have a user defined grid that populates using a stored procedure.
I pass a couple of different field values to the SP, and have it populate the grid.
I then clear the fields.
When I try to delete any of the lines in the grid and save, all the previous grid lines return.
THis only happens with the grid lines populated by the SP. If I manually add a grid line, and then delete it, it won't return.
Anyone run into this before? Any ideas how I can fix this?
THanks

jon_davis
Posts: 1
Joined: Wed Oct 30, 2013 10:46 am
Brief Company Description: Manufacturing and Engineering Services for the Electrical Power industry.
Deltek Vision Version: 6.2
Number of Employees: 4000
Company Position: Analyst/Developer
Vision Modules: Project, Acctg, Billing, Time&Expense, Planning, CRM, Proposals, Multicurrency, Purchasing, Doc Mgmt, Performance
Number of Offices: 0
Year Vision Installed: 2011

Re: Grid Values won't delete if populated by Stored Procedure

Postby jon_davis » Wed Oct 30, 2013 10:56 am

Did you ever resolve this issue? I have an identical problem. Ironically, I have other custom grids on the same InfoCenter (Project) for which I also insert rows using a stored procedure and these grids do not have the issue.

Emma Howard
Posts: 28
Joined: Fri May 25, 2012 6:19 am
Brief Company Description: WSP Group Africa - 900 users in Africa, subsidiary of WSP Group PLC - 9000 users worldwide, Deltek Vision user since 2009. Engineering company supplying all engineering services from Mechanical through to Green Energy
Deltek Vision Version: 6.1
Number of Employees: 900
Company Position: Deltek Project Manager
Vision Modules: Info Centres, Accounting, Time and Expense, CRM, Custom Proposals
Number of Offices: 0
Year Vision Installed: 2009

Re: Grid Values won't delete if populated by Stored Procedure

Postby Emma Howard » Sat Nov 09, 2013 2:05 am

If you are populating by stored procedure, is your stored procedure not re-running and re-populating the fields. Also try this stored procedure to clear



/****** Object: StoredProcedure [dbo].[_ClearCustom_sp] Script Date: 08/09/2011 14:15:22 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[_ClearCustom_sp]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[_ClearCustom_sp]
GO



/****** Object: StoredProcedure [dbo].[_ClearCustom_sp] Script Date: 08/09/2011 14:15:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




Create proc [dbo].[_ClearCustom_sp]
@ref VARCHAR (255)
, @table varchar (255)
, @info varchar (20)


as

begin



declare @cmd varchar (8000)


select @cmd = 'delete ' + @table + ' where ' + @info +' = ' + ''''+ @ref +''''

--select @cmd
exec (@cmd)




end
GO


Return to “User Initiated & Scheduled Workflows”

Who is online

Users browsing this forum: No registered users and 1 guest