Home  >  Article  >  Database  >  Date value is not populated when inserting order using native SQL in SAP

Date value is not populated when inserting order using native SQL in SAP

WBOY
WBOYforward
2023-08-25 13:13:06637browse

在 SAP 中使用本机 SQL 插入订单时,日期值未填充

I think you need to add a colon before the variable like this:

EXEC SQL.
   INSERT INTO order VALUES('2', :sy-datum)
ENDEXEC.

I also recommend you to use OpenSQL here instead of Native SQL. When you try to use any database-specific functionality, native SQL is used.

The query you are using is very general and not specific to the backend database.

The above is the detailed content of Date value is not populated when inserting order using native SQL in SAP. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete