rishabh wrote: > i put a cout on the insert query string generated by mprintf. > it was actually putting the table name within quotes itself, so > putting the extra quotes was not required.
%Q surrounds the name with the wrong type of quotes. %Q uses single quotes (as in 't-t'), as required in SQL for string literals. For names, you should use double quotes (as in "t-t"): %Q won't help you with that, use plain vanilla %s and put the quotes in yourself. > now the insert command is not giving any error, but the values did not > actually get inserted :( How do you determine this? I suggest you prepare and post a small sample program that reproduces your problem. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
