Skip to Content
0
Jun 27 at 10:04 AM

error-in-the-execution-of-the-query-in-sql-server

215 Views Last edit Jul 15 at 08:45 AM 2 rev

My contract table :

image.png

My contractItem table:

image.png

My product table:

image.png

My sum function for set up the Total Amount at the contract table:

image.png

When I am using the "Insert Into "SQL to insert data into the contract data, there has an error occur:

image.png

I tried to use UPDATE sql also have the same error occur :

image.png

May you guys help me to resolve the problem?

Thanks for your help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Attachments

image.png (19.5 kB)
image.png (19.5 kB)
image.png (14.8 kB)
image.png (19.8 kB)
image.png (50.7 kB)
image.png (47.1 kB)
image.png (58.0 kB)