SQL Error Message -
why error saying sql command not ended when have code:
select materialid, materialname, materialtypeid, curecodeid, combinationcode, materialstatusid, activated, deactivated material_header materialid = 112, materialname = 3, materialtypeid = 2, curecodeid = 0, combinationcode = 3, materialstatusid = 3; i've tried not including semicolon, parenthesis , other stuff none has worked.
try
select materialid, materialname, materialtypeid, curecodeid, combinationcode, materialstatusid, activated, deactivated material_header materialid = 112 , materialname = 3 , materialtypeid = 2 , curecodeid = 0 , combinationcode = 3 , materialstatusid = 3; and instead of ,
Comments
Post a Comment