Error Number: 1526

This is a multi-part message in MIME format.

------_=_NextPart_001_01C82098.7B9D7576
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

Having a little issue, and can't seem to figure it out!

Every time I try to run this insert command I get this error:

select code, name, fee, med_tos, cpt_code FROM billing_code WHERE code
=3D '11100'

SELECT bill_code, fee_code, amount, med_tos, cpt_code FROM fee_detail
WHERE bill_code =3D '11100' and fee_code =3D 'STANDARD'

insert into billing_detail (item, sub_item, clienttype, client, patient,
invoice, date, end_date, age_date, employee, user_code, user_time,
user_date, code, code_type, diag, med_pos, med_tos, mod1, mod2, descr,
amount, units, extended, item_bal, bill_pat, bill_ins, bill_never,
deduct, pat_resp, est_done, est_billed, taxable, posted, inventory,
inv_posted, paid, note_ins, note_stmt, emg, notes) VALUES (1,
1,'S','KENA000002','KENA000002',76964,'2007-11-06','2007-11- 06','2007-11
-06','','','12:02 PM','2007-11-06','11100','CH','1234', '', '01', '',
'', 'BX, SKIN, SUBQ/MUCOUS MEMBRANE (SEP PROC', 150.00, 1, 150.00,
150.00, FALSE, FALSE, FALSE, TRUE, 0.00, FALSE, FALSE, FALSE, FALSE,
1.00, FALSE, FALSE, FALSE, FALSE, 'N', 'Imported From SOAPware')
Error Number: 1526
Error: Connectivity error: ERROR: duplicate key violates unique
constraint "billing_detail_pkey";Error while executing the query
12:02:39.452 PM

What's more interesting is if I exit everyone out of the program or run
this on a not shared version of the program the command works fine!?

Only one constraint:

-- Constraint: billing_detail_pkey

-- ALTER TABLE billing_detail DROP CONSTRAINT billing_detail_pkey;

ALTER TABLE billing_detail
ADD CONSTRAINT billing_detail_pkey PRIMARY KEY(rec_no);

Any help is appreciated!=20

Thanks,

Shahid Khan=20


------_=_NextPart_001_01C82098.7B9D7576
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable




charset=3Dus-ascii">
6.5.7235.2">

FACE=3D"Calibri">Hello,

Having a little =
issue, and can FACE=3D"Calibri">’ FACE=3D"Calibri">t seem to figure it out!

Every time I =
try to run =
this insert command I get this error:

FACE=3D"Calibri">  FACE=3D"Calibri">select code, name, fee, med_tos, cpt_code FROM =
billing_code WHERE code =3D '11100'

SELECT =
bill_code, fee_code, amount, med_tos, cpt_code FROM fee_detail WHERE =
bill_code =3D '11100' and fee_code =3D 'STANDARD'

insert into =
billing_detail (item, sub_item, clienttype, client, patient, invoice, =
date, end_date, age_date, employee, user_code, user_time, user_date, =
code, code_type, diag, med_pos, med_tos, mod1, mod2, descr, amount, =
units, extended, item_bal, bill_pat, bill_ins, bill_never, deduct, =
pat_resp, est_done, est_billed, taxable, posted, inventory, inv_posted, =
paid, note_ins, note_stmt, emg, notes) VALUES (1, =
1,'S','KENA000002','KENA000002',76964,'2007-11-06','2007-11- 06','2007-11-=
06','','','12:02 PM','2007-11-06','11100','CH','1234', '', '01', '', '', =
'BX, SKIN, SUBQ/MUCOUS MEMBRANE (SEP PROC', 150.00, 1, 150.00, 150.00, =
FALSE, FALSE, FALSE, TRUE, 0.00, FALSE, FALSE, FALSE, FALSE, 1.00, =
FALSE, FALSE, FALSE, FALSE, 'N', 'Imported From =
SOAPware')

Error Number: =
1526

Error: =
Connectivity error: ERROR: duplicate key violates unique constraint =
"billing_detail_pkey";Error while executing the =
query

12:02:39.452 =
PM

FACE=3D"Calibri">What FACE=3D"Calibri">’ FACE=3D"Calibri">s more interesting is if I exit everyone out of the =
program or run this on a not shared version of the program the command =
works fine!?

Only =
one FACE=3D"Calibri">constraint FACE=3D"Calibri">:

-- Constraint: =
billing_detail_pkey

-- ALTER TABLE =
billing_detail DROP CONSTRAINT billing_detail_pkey;

ALTER TABLE =
billing_detail

  ADD =
CONSTRAINT billing_detail_pkey PRIMARY KEY(rec_no); LANG=3D"en-us">

Any help is =
appreciated!

FACE=3D"Calibri">Thanks,

LANG=3D"en-us"> LANG=3D"en-us">Shahid Khan SIZE=3D2 FACE=3D"Arial">

Re: Error Number: 1526

Shahid Khan wrote:
> Hello,
>=20
> Having a little issue, and can=92t seem to figure it out!
>=20
> Every time I try to run this insert command I get this error:
>=20
> select code, name, fee, med_tos, cpt_code FROM billing_code WHERE code=
=20
> =3D '11100'
>=20
> SELECT bill_code, fee_code, amount, med_tos, cpt_code FROM fee_detail=20
> WHERE bill_code =3D '11100' and fee_code =3D 'STANDARD'
>=20
> insert into billing_detail (item, sub_item, clienttype, client, patient=
,=20
> invoice, date, end_date, age_date, employee, user_code, user_time,=20
> user_date, code, code_type, diag, med_pos, med_tos, mod1, mod2, descr,=20
> amount, units, extended, item_bal, bill_pat, bill_ins, bill_never,=20
> deduct, pat_resp, est_done, est_billed, taxable, posted, inventory,=20
> inv_posted, paid, note_ins, note_stmt, emg, notes) VALUES (1,=20
> 1,'S','KENA000002','KENA000002',76964,'2007-11-06','2007-11- 06','2007-1=
1-06','','','12:02=20
> PM','2007-11-06','11100','CH','1234', '', '01', '', '', 'BX, SKIN,=20
> SUBQ/MUCOUS MEMBRANE (SEP PROC', 150.00, 1, 150.00, 150.00, FALSE,=20
> FALSE, FALSE, TRUE, 0.00, FALSE, FALSE, FALSE, FALSE, 1.00, FALSE,=20
> FALSE, FALSE, FALSE, 'N', 'Imported From SOAPware')
>=20
> Error Number: 1526
>=20
> Error: Connectivity error: ERROR: duplicate key violates unique=20
> constraint "billing_detail_pkey";Error while executing the query
>=20
> 12:02:39.452 PM
>=20
> What=92s more interesting is if I exit everyone out of the program or r=
un=20
> this on a not shared version of the program the command works fine!?
>=20
> Only one constraint:
>=20
> -- Constraint: billing_detail_pkey
>=20
> -- ALTER TABLE billing_detail DROP CONSTRAINT billing_detail_pkey;
>=20
> ALTER TABLE billing_detail
>=20
> ADD CONSTRAINT billing_detail_pkey PRIMARY KEY(rec_no);

How is the rec_no field defined ?

regards,
Hiroshi Inoue


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate