| Category: |
Microsoft OLE DB Provider for ODBC Drivers |
| ASPCode: |
|
| ASPDescription: |
|
| Number: |
-2147217900 |
| Description: |
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'inv_qty', table 'wirelessemp_db.dbo.we_ItemsSiteReady'; column does not allow nulls. UPDATE fails. |
| File: |
/product_mp.asp |
| Source: |
|
| Column: |
-1 |
| Line: |
83 |
| errorSQL: |
update we_ItemsSiteReady set inv_qty = (select top 1 b.inv_qty from we_Items a left join we_Items b on a.PartNumber = b.PartNumber and b.master = 1 where a.itemID = 7338 order by b.inv_qty desc) where itemID = 7338 |
| errorSQL2: |
|