25.11.2009, 20:30
I've just started learning and trying out SQLite.
I've seen a few, but not many examples on SAMP forums of how to use it and certain functions.
I've created this as a test. The only thing i really have to open it is notepad
The reason i want to open it is to check to see whats actually gone inside, and see if its working..
So here is the code...
http://pastebin.com/m38c8192b
Indention went a little bit tits up when i pasted it in pastebin, but it isnt too bad.
Here is the result i find when i start the server, and the users.s3db file has been created.
http://pastebin.com/m4b6f1fdd
Remeber, it was opened in notepad, so that is pasted from notepad.
Then here is what its like after i connect...
http://pastebin.com/m736b591e
So, questions are.
What is that about? It obviously hasn't worked right because tyhe information i was wanting to insert into there hasnt worked when i connected.
Are there any programs i can use to view the database fully, as a database should look. Rather than using notepad?
What did i do wrong in that code?
I saw some examples, and mine seemed to comply with those.
I've seen a few, but not many examples on SAMP forums of how to use it and certain functions.
I've created this as a test. The only thing i really have to open it is notepad
The reason i want to open it is to check to see whats actually gone inside, and see if its working..
So here is the code...
http://pastebin.com/m38c8192b
Indention went a little bit tits up when i pasted it in pastebin, but it isnt too bad.
Here is the result i find when i start the server, and the users.s3db file has been created.
http://pastebin.com/m4b6f1fdd
Remeber, it was opened in notepad, so that is pasted from notepad.
Then here is what its like after i connect...
http://pastebin.com/m736b591e
So, questions are.
What is that about? It obviously hasn't worked right because tyhe information i was wanting to insert into there hasnt worked when i connected.
Are there any programs i can use to view the database fully, as a database should look. Rather than using notepad?
What did i do wrong in that code?
I saw some examples, and mine seemed to comply with those.