You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a database table that has nullable columns and I want to multiple rows in one go. The data contains null values in various places. As in, I cannot just leave out an entire column in my insert statement but rather need an explicit way to insert null.
Is that currently possible? If yes, how would I do that?
The text was updated successfully, but these errors were encountered:
Original comment by Xu Meng (Bitbucket: mengxumx, GitHub: dmabupt).
Yes, indicator 3 tells idb-connector the parameter is null -->
[null, db.SQL_PARAM_INPUT, 3]
This is the old way to set the data type, but from v1.0.9, it can automatically detect the data types. Considering compatibility, I still keep the indicator 0(CLOB), 1(null-terminated-string), 2(integer), 3(null) and added two new types 4(decimal), 5(boolean) --
Original report by Kerim Gueney (Bitbucket: KerimG, GitHub: KerimG).
I have a database table that has nullable columns and I want to multiple rows in one go. The data contains null values in various places. As in, I cannot just leave out an entire column in my insert statement but rather need an explicit way to insert null.
Is that currently possible? If yes, how would I do that?
The text was updated successfully, but these errors were encountered: