首頁猿問使用 Python 從 SAP...

使用 Python 從 SAP Hana 加載數(shù)據(jù)時出現(xiàn)語法錯誤

Python

天涯盡頭無女友 2023-03-08 10:39:05

我在通過 Python 從 SAP HANA 加載數(shù)據(jù)時遇到問題。代碼在以下情況下工作正常：connection = pyhdb.connect(|||credentials|||)cursor = connection.cursor()cursor.execute('SELECT "0COMP_CODE", "0VENDOR", "0REF_DOC_NO", "0BBP_INV_ID" FROM "_SYS_BIC"."system-local.bw.bw2hana/ZFGL01MY" WHERE CAST( "0PSTNG_DATE" AS date) >= ADD_MONTHS( NEXT_DAY( LAST_DAY( CURRENT_DATE)), -2) and "0VENDOR" IS NOT NULL')但是當我試圖添加像“0COMP_CODE”='B2B'這樣的條件時，所以它看起來像這樣：Connection = pyhdb.connect(|||credentials|||)cursor = connection.cursor()cursor.execute('SELECT "0COMP_CODE", "0VENDOR", "0REF_DOC_NO", "0BBP_INV_ID" FROM "_SYS_BIC"."system-local.bw.bw2hana/ZFGL01MY" WHERE CAST( "0PSTNG_DATE" AS date) >= ADD_MONTHS( NEXT_DAY( LAST_DAY( CURRENT_DATE)), -2) and "0VENDOR" IS NOT NULL AND "0COMP_CODE" = 'B2B' ')我越來越SyntaxError: invalid syntax.我做錯了什么？

查看完整描述

1 回答

青春有我

TA貢獻1784條經(jīng)驗獲得超8個贊

嘗試轉義單引號：

Connection = pyhdb.connect(|||credentials|||)

cursor = connection.cursor()

cursor.execute('SELECT "0COMP_CODE", "0VENDOR", "0REF_DOC_NO", "0BBP_INV_ID" FROM "_SYS_BIC"."system-local.bw.bw2hana/ZFGL01MY" WHERE CAST( "0PSTNG_DATE" AS date) >= ADD_MONTHS( NEXT_DAY( LAST_DAY( CURRENT_DATE)), -2) and "0VENDOR" IS NOT NULL AND "0COMP_CODE" = \'B2B\' ')

反對回復 2023-03-08