RE:Ayuda con PK Compuesta
Holas..
Ya solucione mi problema..... Solo era un error de datos, ya que estaba ingresando en el doc entry un dato que ya existia..
------------- ERROR ----------------
declare @docentry int
declare @doc int
declare @num int
declare @lin int
set @docentry =5
select @doc=(count(docentry))+1 from opdn
INSERT INTO OPDN
(DocEntry, DocNum, CardCode, CardName, NumAtCard,DocDate, DocDueDate, TaxDate)
(
SELECT
@doc,@doc,T0.CardCode, T0.CardName, T0.NumAtCard, T0.DocDate, T0.DocDueDate, T0.TaxDate
FROM
OPOR T0
WHERE
T0.Docentry =@docentry
)
print @doc
INSERT INTO PDN1
(DocEntry,LineNum,ItemCode, Dscription, Quantity, DiscPrcnt, TaxCode, U_cod_z, U_val_cif, U_porc_imp, U_val_cif_t)
(
SELECT
@DocEntry ------------------------> DATOS YA EXISTENTE EN LA TABLA
,T1.LineNum,T1.ItemCode, T1.Dscription, T1.Quantity, T1.DiscPrcnt, T1.TaxCode, T1.U_cod_z, T1.U_val_cif, T1.U_porc_imp, T1.U_val_cif_t
FROM
POR1 T1
WHERE
T1.Docentry =@docentry
)
---------------------- MODIFICADO -----------------------------
declare @docentry int
declare @doc int
declare @num int
declare @lin int
set @docentry =5
select @doc=(count(docentry))+1 from opdn
INSERT INTO OPDN
(DocEntry, DocNum, CardCode, CardName, NumAtCard,DocDate, DocDueDate, TaxDate)
(
SELECT
@doc,@doc,T0.CardCode, T0.CardName, T0.NumAtCard, T0.DocDate, T0.DocDueDate, T0.TaxDate
FROM
OPOR T0
WHERE
T0.Docentry =@docentry
)
print @doc
INSERT INTO PDN1
(DocEntry,LineNum,ItemCode, Dscription, Quantity, DiscPrcnt, TaxCode, U_cod_z, U_val_cif, U_porc_imp, U_val_cif_t)
(
SELECT
@doc,---------------------------> NUEVO DATO EL CUAL NO EXISTE EN LA TABLA
T1.LineNum,T1.ItemCode, T1.Dscription, T1.Quantity, T1.DiscPrcnt, T1.TaxCode, T1.U_cod_z, T1.U_val_cif, T1.U_porc_imp, T1.U_val_cif_t
FROM
POR1 T1
WHERE
T1.Docentry =@docentry
)
Gracias...