Hi all. I'm writing a generic csv importing thing in C ( partly as a project to teach me C ). So far I've got parsing of the CSV header row ( ie field headers ) and construction of the 'insert into' statement working, with field names and '?' placeholders for bind variables.
Next comes the binding bit. I was a bit surprised to find a separate function per data type. Is this going to be a problem? Assuming I've created the table with the correct data type for each column, if I just use, for example, sqlite3_bind_text on all data, will the correct thing happen? Or do I have to call the 'correct' function for each column I bind? I'm not really sure how this 'column affinity' works ... Thanks. Dan _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
