Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update query in SQL 2005 - Item not bound

Status
Not open for further replies.

load3d

Programmer
Feb 27, 2008
117
US
I'm trying to create a scheduled job to update the "Status" Column in my tbl_InboundShipments to "In Yard" where the Inbound# matches the Company# in a query that shows trucks that are checked in. What am I doing wrong?


UPDATE dbo.tbl_InboundShipments
SET dbo.tbl_inboundshipments.Status = "InYard"
WHERE dbo.qry_TrucksCheckedIn.Company = dbo.tbl_inboundshipments.CSinbound


GO

 
Literal strings need to be wrapped in single quotes, not double quotes.
 
Thanks for the prompt response. I'm still getting an error though "Item could not be bound dbo.qry_TrucksCheckedIn.Company"
 
Okay, I got it. Thanks again River Guy you probably saved me a few failed test jobs.


UPDATE dbo.tbl_InboundShipments
SET dbo.tbl_inboundshipments.[Status] = 'InYard'
FROM dbo.tbl_inboundshipments, dbo.qry_TrucksCheckedInFF
WHERE dbo.qry_TrucksCheckedInFF.[Company] = dbo.tbl_inboundshipments.CSINBOUND


GO

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top