|
From: | Meketon, Marc |
Subject: | Bug in 'table' statement |
Date: | Tue, 4 Feb 2020 19:38:18 +0000 |
The following code fails when writing out records to a Microsoft Access database. You would need to create a table called ‘result’ with a numeric field called ‘Day’ to run the below (as well as change the name/path of the database) param odbc_driver symbolic := 'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};dbq=.\data.accdb'; table PUT_RESULTS_1 {d in 1..10} OUT 'ODBC' odbc_driver 'DELETE FROM result; ' # NOTE THE SPACE AFTER THE ; 'result' : d ~ Day ; The issue is the space after the ‘;’ in the DELETE statement. If you took it out, it works. That is, the following works: param odbc_driver symbolic := 'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};dbq=.\data.accdb'; table PUT_RESULTS_1 {d in 1..10} OUT 'ODBC' odbc_driver 'DELETE FROM result;' # NOTE THE LACK OF A SPACE
# BETWEEN THE ; and the end-quote 'result' : d ~ Day ; Marc Meketon
ASSISTANT |
[Prev in Thread] | Current Thread | [Next in Thread] |