My values come from an HTML which I've already parsed with C. I figured out how to do Select command and was able to print out my table but I can't seem to figure out how to do the Insert, Update and Delete commands. Can anyone give me a sample code please? Thank you
Documentation on the SQL dialect's syntax and C interface is available from the SQLite website.
Look up a C++ Reference and learn How To Ask Questions The Smart WayOriginally Posted by Bjarne Stroustrup (2000-10-14)
Take the code that does your SELECT calls, change it so that it has the relevant DELETE or INSERT or UPDATE command instead. Not really that hard. Nothing to do with C, either, you're basically working with SQL when you get to the point that you're sending strings to SQL with SELECT etc. inside them.
- Compiler warnings are like "Bridge Out Ahead" warnings. DON'T just ignore them.
- A compiler error is something SO stupid that the compiler genuinely can't carry on with its job. A compiler warning is the compiler saying "Well, that's bloody stupid but if you WANT to ignore me..." and carrying on.
- The best debugging tool in the world is a bunch of printf()'s for everything important around the bits you think might be wrong.
