Re: Error Number: 1526

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