Skip to main content
Salesforce

Return to Answer

added 1 character in body
Source Link
Adrian Larson ♦
Adrian Larson ♦
  • 151.4k
  • 38
  • 247
  • 431

You're mixing up your variables. When you use merge syntax in SOQL, you must use the name of an existing variable in your scope. So if you had a variable called stockId, you could use: 'WHERE Id = :stockId'. You can't do any cross-references, though, so stock.Id cannot be merged in.

However, if you use 'WHERE Id = :'' + stockId, you get a resulting query string of 'WHERE Id = :a0236000001bOXdAAM'. Since you do not have a variable called a0236000001bOXdAAM, you get an error.

You're mixing up your variables. When you use merge syntax in SOQL, you must use the name of an existing variable in your scope. So if you had a variable called stockId, you could use: 'WHERE Id = :stockId'. You can't do any cross-references, though, so stock.Id cannot be merged in.

However, if you use 'WHERE Id = :'' + stockId, you get a resulting query string of 'WHERE Id = a0236000001bOXdAAM'. Since you do not have a variable called a0236000001bOXdAAM, you get an error.

You're mixing up your variables. When you use merge syntax in SOQL, you must use the name of an existing variable in your scope. So if you had a variable called stockId, you could use: 'WHERE Id = :stockId'. You can't do any cross-references, though, so stock.Id cannot be merged in.

However, if you use 'WHERE Id = :'' + stockId, you get a resulting query string of 'WHERE Id = :a0236000001bOXdAAM'. Since you do not have a variable called a0236000001bOXdAAM, you get an error.

Source Link
Adrian Larson ♦
Adrian Larson ♦
  • 151.4k
  • 38
  • 247
  • 431

You're mixing up your variables. When you use merge syntax in SOQL, you must use the name of an existing variable in your scope. So if you had a variable called stockId, you could use: 'WHERE Id = :stockId'. You can't do any cross-references, though, so stock.Id cannot be merged in.

However, if you use 'WHERE Id = :'' + stockId, you get a resulting query string of 'WHERE Id = a0236000001bOXdAAM'. Since you do not have a variable called a0236000001bOXdAAM, you get an error.