lcroito

This is the parent store procedure:

CREATE PROC dbo.usp_DCP_pub_get_vCSCursuri
@mandant int
AS

SET NOCOUNT ON

SELECT IDMandant,IDCSCurs,DenCSCurs,DescriereCSCurs,IDCSCategCurs,IDCSNivelCu rs,IDCSGrupTinta,IDCSNecesitate,CunostinteNecesare,ObiectiveCurs
FROM vCSCursuri
WHERE IDMandant=@mandant
GO

and, this ist the child store procedure:

CREATE PROC dbo.usp_DCP_pub_get_vCSTematica
@mandant int
AS

SET NOCOUNT ON

SELECT IDMandant,IDCSCurs,IDCSTematica,DenTematica,Durata
FROM vCSTematica
WHERE IDMandant=@mandant
GO

I assign first store procedure to Command1 and second to Command2

I defined relationship in Command2
IDMandant <--> mandant,
because VB want that. (the child parameter must to be in relation)

I assign the command1 to datareport, I run Retrive Structure, include the field in raport and run Datareport.
That generate one error mesage: "General error"

If change the child command2 with view vCSTematica, I do not have error.
I think the problem is with relation
IdMandant <--> mandant.

Help me please