SQLITE: Creating a table from within C+
Okay, my vocabulary trainer works.
what I want to do now is program a small editor for the database.
here the user creates "lessons"(tables) in his vocabulary book.
he selects the lesson to be used in this menu aswell as to delete and add vocabulary entries.
I can display the tables and their content, but...
how do i go about creating a table?
CREATE TABLE Beta (ID INTEGER PRIMARY KEY, english TEXT, german TEXT);
works for my SQLITE frontend, but in my code it does nothing....
:/
at least it seems to do nothing.
the database wont create a new table this way.
nothing happens.
the code itself is clean and executes.
but somehow the sql query is wierd
if i enter a different sql query, it works.
Maybe "ID" is a reserved keyword, and you have to properly escape it? I have had that happen to me quite a lot in MySQL.
Doesn't it at least return an error code/exception?