Confirmation after insert and delete in VC

[Former Member]

Hi,

I would like to inform the user the action is successful after insert and delete. I am using VC on EP 7.4, stored procedure on SQL server 2005.

I can't get return value in VC data service no matter I add output parameter or using select after insert/delete in the stored procedure.

Any idea how to achieve this?

Thanks in advance.

[mark_moshkovich]

Hi Natalie,

There is a bug in our WD4CV runtime.

We will fix it in the next releases.

Regards,

Mark

[natalie_zhang3]

Thank you, Mark. This is a good news. Could you please let me know the release number, so I can upgrade my portal once it is out. This is one of the major enhancements my business user asked for. Thanks.

[mark_moshkovich]

Hi Natalie,

I would be better if you open a medium customer message, so we could fix this issue with priority.

Regards,

Mark

[mark_moshkovich]

Hi Natalie,

Could you provide me with the code of the stored procedure and involved table definitions?

Regards,

Mark

[natalie_zhang3]

Hi Mark,

Here is my procedure:

ALTER PROCEDURE [dbo].[sp_insertEscalationManager]

  (

  @userid varchar(20),

  @escalation_manager_email varchar(200)

  )

AS

  SET NOCOUNT OFF

  insert into Table_Emergency_Escalation (user_id, escalation_manager_email)

  values (@userid, @escalation_manager_email)

  RETURN

The table only have 3 columns:

id int not null,  - system auto increase the number by 1 for each insert

user_id (nvarchar(50)) not null,

escalation_manager_email (nvarchar(250)) not null

I tested the data service in VC model, I can see the return value returns 0 when I did "test data service". But when I dragged out an table view from output port of the data service, and then preview the model, there is nothing on the iview.

Please help. Thanks.