Home > Database > Mysql Tutorial > body text

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

WBOY
Release: 2023-08-25 13:13:06
forward
643 people have browsed it

在 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.
Copy after login

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!

source:tutorialspoint.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template