我正在努力解决关于MS-Access的以下问题:
UPDATE
(
(
DWH_TICKERS_LIST
INNER JOIN ODS_PAGE_HEADER_INFO ON ODS_PAGE_HEADER_INFO.TICKER_CODE = DWH_TICKERS_LIST.TICKERS_LIST__TICKER
)
INNER JOIN SECTOR ON SECTOR.NAME = DWH_TICKERS_LIST.TICKERS_LIST__NAME
)
SET
DWH_TICKERS_LIST.TICKERS_LIST__ISIN_CODE = ODS_PAGE_HEADER_INFO.ISIN_CODE
, DWH_TICKERS_LIST.TICKERS_LIST__CURR = ODS_PAGE_HEADER_INFO.CURR
, DWH_TICKERS_LIST.TICKERS_LIST__SECTOR_FK = SECTOR.SECTOR_PK
, DWH_TICKERS_LIST.TICKERS_LIST__TOTALVOLUME = ODS_PAGE_HEADER_INFO.TOTALVOLUME
, DWH_TICKERS_LIST.TICKERS_LIST__ELIGIBILITY_SRD = ODS_PAGE_HEADER_INFO.ELIGIBILITY_SRD
, DWH_TICKERS_LIST.TICKERS_LIST__ELIGIBILITY_PEA = ODS_PAGE_HEADER_INFO.ELIGIBILITY_PEA
, DWH_TICKERS_LIST.TICKERS_LIST__ELIGIBILITY_22H = ODS_PAGE_HEADER_INFO.ELIGIBILITY_22H
, DWH_TICKERS_LIST.DWH_TICKERS_LIST__UPDATE_DATETIME = Now()
我得到了that one的启发. 但是我得到了这个错误:
sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('07002', '[07002] [Microsoft][Pilote ODBC Microsoft Access] Trop peu de paramètres. 1 attendu. (-3010) (SQLExecDirectW)')
即参数太少,预期为1.
你知道怎么改正这个错误吗?