Urgent : Error (-268) : Unique constraint (dbasis.ct_hc_dtmpplanilla1) violated.
Hi,
I have a problem :
A user ran a query :
SELECT * FROM HC_DTMPPLANILLA where periodo = '2003' and mes = '04' andcip = '01718358' and coddesc = 'V345'
-- No data returned.
** -- Not problem...
But when the same end user, run a SP with the same values that the query, and there aren't records, i saw the following error... Why?
EXECUTE PROCEDURE SpPlanilla_InsertConsumo('2003','04','01718356','V345',279.53)
-- SQL Error (-268) : Unique constraint (dbasis.ct_hc_dtmpplanilla1) violated. [ ISAM error -100 : ISAM error: duplicate value for a record with unique key.
** -- Problems..!!!
My dbschema :
dbschema -d cemena -t hc_dtmpplanilla
create table "dbasis".hc_dtmpplanilla
(
periodo char(4),
mes char(2),
cip char(8),
coddesc char(6),
impsaldo decimal(10,2),
impconsumo decimal(10,2),
impdescplani decimal(10,2),
impnodescplani decimal(10,2),
imppago decimal(10,2),
impmonto decimal(10,2),
impmontonoenv decimal(10,2),
primary key (periodo,mes,cip,coddesc) constraint "dbasis".ct_hc_dtmpplanilla1
) extent size 32 next size 32 lock mode page;
revoke all on "dbasis".hc_dtmpplanilla from "public";
Thanks
Omar.
LUQUE Valdivia Omar - DBA Marina wrote in message ...
>
>Hi,
>
>I have a problem :
>
>A user ran a query :
>
>SELECT * FROM HC_DTMPPLANILLA where periodo = '2003' and mes = '04' and>cip = '01718358' and coddesc = 'V345'
>-- No data returned.
>
>** -- Not problem...
>
>But when the same end user, run a SP with the same values that the query,
and there aren't records, i saw the following error... Why?
>
>EXECUTE PROCEDURE
SpPlanilla_InsertConsumo('2003','04','01718356','V345',279.53)
Maybe it's just a typo, but '01718358' != '01718356'
>
>-- SQL Error (-268) : Unique constraint (dbasis.ct_hc_dtmpplanilla1)
violated. [ ISAM error -100 : ISAM error: duplicate value for a record with
unique key.
>
>** -- Problems..!!!
>
>
>My dbschema :
>
>dbschema -d cemena -t hc_dtmpplanilla>
>create table "dbasis".hc_dtmpplanilla
> (
> periodo char(4),
> mes char(2),
> cip char(8),
> coddesc char(6),
> impsaldo decimal(10,2),
> impconsumo decimal(10,2),
> impdescplani decimal(10,2),
> impnodescplani decimal(10,2),
> imppago decimal(10,2),
> impmonto decimal(10,2),
> impmontonoenv decimal(10,2),
> primary key (periodo,mes,cip,coddesc) constraint
"dbasis".ct_hc_dtmpplanilla1
> ) extent size 32 next size 32 lock mode page;
>revoke all on "dbasis".hc_dtmpplanilla from "public";>
>
>Thanks
>
>
>Omar.
>
>