Thanks for the reply. To answer your question, semi-colons are not needed when executing a single SQL statement.
As regarding the other matter, the table is indeed created and accepts insertion of NULL values, but that was not the problem. I am beginning to believe that maybe I was wrong in my assumption that 'if a table has an index, that index shows in sqlite_master'. Then my problem is now to find another way to get index information for a table. Any suggestions? Regards, Bogdan
