Update query error

Question

I am trying to update records in table tciSTran that are present in the table tarRecurInvcLineDS

Here is the query I wrote...

 update [mas500_test_app].[dbo].[tciSTaxTran] 
 set STaxSchdKey = 310
 where STaxTranKey in
 (select STaxTranKey  from [mas500_test_app].[dbo].[tarRecurInvcLineDs]

I'm getting this error

Unable to update the tciSTaxTran record because it is trying to reference a record in tciSTaxSchedule that does not exist.

Eric Petroelje · Accepted Answer · 2012-12-26 19:22:41Z

1

Seems you have a foreign key between tciSTaxTran.STaxSchdKey and the tciSTaxSchedule table. Does the tciSTaxSchedule table have a row with a primary key of 310?

answered Dec 26, 2012 at 19:22

Eric Petroelje

60.7k9 gold badges133 silver badges178 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update query error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related