Hi all,
I am changing over from fastinsert to datainsert and I am having an issue inserting blank spaces to my SQL table.
Ex: a = {''};
Old code (works): fastinsert(conn,tableName,fieldNames,a);
New code (doesn't work): datainsert(conn,tableName,fieldNames,a);
datainsert treats the blank character as empty, and inserts a NULL value to the table. Is there a way to force it to intrepret this as a blank character instead?
Thanks!
Best Answer