Hi all, I have this section in my script, because I have a button to launch partial reload and to add only new rows, but when I launch partial reload in the log I get this error (ProposalID is the primary key):
20230523T115658.884+0200 0369 Add Only
20230523T115658.884+0200 0370 SQL
20230523T115658.884+0200 0371 SELECT * FROM Proposals
20230523T115658.884+0200 0372 WHERE NOT EXISTS(ProposalID)
20230523T115700.059+0200 1 fields found: *,
20230523T115700.064+0200 Error: ERROR [42000] Incorrect syntax near 'ProposalID'.,
20230523T115700.159+0200 Execution Failed
20230523T115700.175+0200 Execution finished.
LIB CONNECT TO 'StockCutter (db_qlikdev)';
[ORDER_PROPOSALS]:
load * ;
SQL
SELECT * FROM Proposals;
Add Only
SQL
SELECT * FROM Proposals
WHERE NOT EXISTS(ProposalID);
