Bank Sim SQL

Nov 3, 2014 at 1:36am
Hi

I've built a bank simulator just using an empty project and a .cpp file to write my code. What I want to be able to do is to be able to write all that info (account numbers, deposits, withdrawals etc) to an SQL database. I've been all over the net and looking for solutions but with no success. Ye I've had pp just tell me to look up examples.

I would like some advice and ask a few questions:

1) When I do this can I just use Empty projects with your normal .cpp file with all my code or do I need to do some setup.

2) I'm pretty damn sure I need to download something extra...like Xampp or SQLAPI, but I get the feeling there's no need for that.

3) Do I need to make multiple files in my project. i.e. something with the simulator code then something else to do all the SQL stuff.

So ye basically every time anything happens in the sim it's logged onto an SQL database. I know it's very simple just use create, insert and delete commands but all my research says it's loads more complicated than that.
Nov 3, 2014 at 11:57am
For the beginning take a look at SQLite:

http://www.sqlite.org/

You find the 'Getting started' there.
Nov 3, 2014 at 2:21pm
I've downloaded everything it says to put the code into my ide. I just get: fatal error C1083: Cannot open include file: 'sqlite3.h': No such file or directory
Nov 3, 2014 at 2:46pm
you need to add the include path in the compiler settings of your IDE
Nov 4, 2014 at 3:41am
I keep getting this message:

fatal error LNK1104: cannot open file 'D:\sqlite\Obj.obj'

What exactly am I suppose to link the linker to?
Nov 4, 2014 at 11:43am
Did you add the sqlite3.c file [somehow] to your project?

http://www.sqlite.org/howtocompile.html

Note that it's not required to make dll/library. Just adding the file to the project should suffice
Topic archived. No new replies allowed.