紧急求助：大家快来看看错误（ora-00933:SQL命令未正确结束）怎样解决？

[woheni2008523]

我在用C#语言和oracle数据库来做一个数据库系统，在做通用查询模块时出现以下情况：

我写了以下两个查询语句：

1）Sql = "select　ProductID as 产品图号,PlaneType as 所属机型,PlaneID as 批架次,TubeName as 产品名称,SingleNum as 单机数量,CraftRoute as 工艺路线 ,Trademark as 材料牌号,Spec as 材料规格,RoughSize as 毛料尺寸,TubeR as 导管外径,TubeThick as 材料壁厚,InputUserID as 录入者,InputDateTime as 录入时间,tubeNo as 导管编号 from SampleTubes " //前面这些在一行
+ swhere;// 这里的swhere是查询条件

2）Sql = "select ProductID as 产品图号,PlaneType as 所属机型,PlaneID as 批架次,BendAngle as 弯曲角度,"
+"BenderSpeed as 弯曲模转速,PushSpeed as 助推速度,BoosterSpeed as 顶推速度,ClampForce as 夹紧力,"
+"PressForce as 压块力,MandrelE as 芯轴伸出量,BallNumber as 球头个数,SteppedRetraction as 是否选择分段抽芯,ModelID as 模具号," //+ 后面的在一行
+"InputUserID as 录入者,InputDateTime as 录入时间 from TechnicsParameter"
+ swhere;


结果是执行第一个查询语句正常而执行第二个查询语句时报错（ora-00933:SQL命令未正确结束），请大家帮忙想想办法，不胜感激！谢谢！

[jin20000]

你的swhere是一样的啊?如果是那样的话,那估计就是条件swhere在第二个SQL没有字段吧

[woheni2008523]

是这样的：我的swhere不一样，是动态变化的，

[wuyq11]

参考

[woheni2008523]

谢谢楼上了，不过我并不是要一次执行多个SQL语句，我一次只执行一个。说的再具体些就是我执行1）查询句是正确的，可是换成2）就报错，我觉得原理是一样的，不应该出错的，可是不知道为啥它就错了，想不出来咋改，请大家快帮忙想想办法！谢谢了

[woheni2008523]

自己顶呀！

[Garnett_KG]

//貌似少了空格

2）Sql = "select ProductID as 产品图号,PlaneType as 所属机型,PlaneID as 批架次,BendAngle as 弯曲角度,"
      +"BenderSpeed as 弯曲模转速,PushSpeed as 助推速度,BoosterSpeed as 顶推速度,ClampForce as 夹紧力,"
        +"PressForce as 压块力,MandrelE as 芯轴伸出量,BallNumber as 球头个数,SteppedRetraction as 是否选择分段抽芯,ModelID as 模具号," //+ 后面的在一行           
  +"InputUserID as 录入者,InputDateTime as 录入时间 from TechnicsParameter    "  //here
  + swhere

[woheni2008523]

Garnett_KG ,您太厉害了，呵呵，就是少了一个空格，问题解决了，太感谢了！加分了！

[西湖边大叔]

dsfdsfdsf

[zhouhangmin]

????怎么办到的

[ydb7459022]

你这个问题是如何解决的啊？我也遇到了