Code: Select all
UPDATE
scorecard
SET
id=?, mo_date=?, region=?, employee=?,
stage_code=?, temp_id=?, category_id=?, first_employed_date=?,
last_employed_date=?
WHERE
id=? AND
region_id=? AND
employee=? AND
broker_stage_code=? AND
temp_id=? AND
category_id=? and
exists(
select 1
from calendar
where scorecard.mo_date = calendar.mo_date and
mo =? and
yr =?);
How do the bind variables get assigned? Basically, how does the '?' get the right input value from the inbound link?
Thanks in advance.