SQLite Forum

Binding unknown to use column default
Login

Binding unknown to use column default

(1) By Paul van Helden (paulvh) on 2020-05-16 11:39:28 [source]

Hi,

Another small and useful request (I think).

If using a prepared cursor to INSERT, then when the input parameters is unknown, you have to use a different prepared cursor to exclude that column. (I don't want to bind a NULL because there is a DEFAULT for the column, specified by DDL).

Something like sqlite3_bind_unknown or sqlite3_bind_default would be great.

Thanks,

Paul.