Thread: Error Number: 1526
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 = '11100'
SELECT bill_code, fee_code, amount, med_tos, cpt_code FROM fee_detail WHERE bill_code = '11100' and fee_code = '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!
Thanks,
Shahid Khan
Shahid Khan wrote: > 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 > = '11100' > > SELECT bill_code, fee_code, amount, med_tos, cpt_code FROM fee_detail > WHERE bill_code = '11100' and fee_code = '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); How is the rec_no field defined ? regards, Hiroshi Inoue