Rob.Ensinger wrote:
NPT-0105: Parameter 'param_project_id' is inconsitently specified.
(Just GUESSing here Rob)
Are the mulltiple references to the parameter (in the different UNION bits) all consistantly aligned to the
same underlying "column" or to
different columns (or even alias's)? And if the latter, does that help at all if you can reconstruct the SQL so that they ARE consistant?
--
What I mean is
blah blah
WHERE ( @WHERE:PARAM:USER_DEF:INTEGER:[color=#ff0000]INV.ID[/color]:PROJECT_ID@ )
blah blah
UNION
blah blah
WHERE ( @WHERE:PARAM:USER_DEF:INTEGER:[color=#ff0000]INV.ID[/color]:PROJECT_ID@ )
blah blah
UNION
blah blah
WHERE ( @WHERE:PARAM:USER_DEF:INTEGER:[color=#ff0000]INV.ID[/color]:PROJECT_ID@ )
blah blah
(consistantly aligned)
blah blah
WHERE ( @WHERE:PARAM:USER_DEF:INTEGER:[color=#ff0000]INV.ID[/color]:PROJECT_ID@ )
blah blah
UNION
blah blah
WHERE ( @WHERE:PARAM:USER_DEF:INTEGER:[color=#ff0000]PRTASK.PRPROJECTID[/color]:PROJECT_ID@ )
blah blah
UNION
blah blah
WHERE ( @WHERE:PARAM:USER_DEF:INTEGER:[color=#ff0000]INV2[/color].ID:PROJECT_ID@ )
blah blah
(different)
As I say just a
GUESS based on that "inconsistanly specified" bit of the error message?