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

Popular posts from this blog

matlab - Deleting rows with specific rules -

jquery - How would i go about shortening this code? And to cancel the previous click on click of new section? -