我的查询产生错误“ORA-00933：SQL 命令未正确结束”在 C++

发布于 2024-10-03 16:36:04 字数 352 浏览 4 评论 0原文

这是我的查询，

    csQuery.Format (_T ("INSERT INTO EFFECTS 
        (EFFECT_NM,EFFECT_VALUE_NUM,EFFECT_DIR_NM,PROJECT_ID_SQ) 
        SELECT '%s',%f,'%s',STACK_GAP.PROJECT_ID_SQ 
        where PROJECT.PROJECT_NM = '%s'"),TDName,TDvalue,TTDdirection,csProjectName);

当我在 C++ 中执行此查询时，我收到 SQL 命令未正确结束的错误，但它在 PL\SQL 中工作正常。

原文

Here is my query

    csQuery.Format (_T ("INSERT INTO EFFECTS 
        (EFFECT_NM,EFFECT_VALUE_NUM,EFFECT_DIR_NM,PROJECT_ID_SQ) 
        SELECT '%s',%f,'%s',STACK_GAP.PROJECT_ID_SQ 
        where PROJECT.PROJECT_NM = '%s'"),TDName,TDvalue,TTDdirection,csProjectName);

I am getting SQL command not properly ended error while i execute this query in C++ but it works correctly in PL\SQL.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

睫毛上残留的泪 2024-10-10 16:36:04

我相信，您需要在 INSERT 查询后添加分号。

csQuery.Format (_T ("INSERT INTO EFFECTS(EFFECT_NM,EFFECT_VALUE_NUM,EFFECT_DIR_NM,PROJECT_ID_SQ) SELECT '%s',%f,'%s',STACK_GAP.PROJECT_ID_SQ where PROJECT.PROJECT_NM = '%s';"),TDName,TDvalue,TTDdirection,csProjectName);

You need to put a semicolon after your INSERT query, I believe.

csQuery.Format (_T ("INSERT INTO EFFECTS(EFFECT_NM,EFFECT_VALUE_NUM,EFFECT_DIR_NM,PROJECT_ID_SQ) SELECT '%s',%f,'%s',STACK_GAP.PROJECT_ID_SQ where PROJECT.PROJECT_NM = '%s';"),TDName,TDvalue,TTDdirection,csProjectName);

回复收藏 0 原文

~没有更多了~