ODBC example for prepared statement doesn't work

General Usage
7

This SQL syntax is correct as I mentioned previously, if I run it manually, it is successful.

"INSERT INTO cool_table VALUES(?, ?, ?)"

It’s the last execution of the prepared statement that isn’t working. The following part shouldn’t be from the DB vendor. This is pure Julia syntax.

for row = 1:size(df, 1)
    # each time we execute the `stmt`, we pass another row to be bound to the parameters
    ODBC.execute!(stmt, [df[row, x] for x = 1:size(df, 2)])
end
1 Like