[sqlite] Delete From Not Working Properly

2014-02-21 Thread Geo Wil
Hello, Yesterday, while working on my game, I noticed that my game data was not updating in my save SQLite3 database. So I started tracking down what was going on and eventually my search lead me to my dData function. How this function works is that you pass a table name and a bool, the bool is

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Kees Nuyt
On Fri, 21 Feb 2014 14:15:10 -0700, Geo Wil wrote: >Hello, > >Yesterday, while working on my game, I noticed that my game data was not >updating in my save SQLite3 database. So I started tracking down what was >going on and eventually my search lead me to my dData function. > >How this function

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Richard Hipp
Please consider adding an error and warning log ( http://www.sqlite.org/errlog.html) to your program to record any errors that SQLite might be encountering. On Fri, Feb 21, 2014 at 4:15 PM, Geo Wil wrote: > Hello, > > Yesterday, while working on my game, I noticed that my game data was not > up

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Geo Wil
1. Windows 7 Ultimate 64-bit 2. Here is the path I am using: void Database::openSave(bool* bErrors) { if (sqlite3_open("*scSave.sqlite*",&dBase) != SQLITE_OK) { *bErrors = true; createBInfo(); d.createBReport("SQL Code 1",sqlite3_errmsg(dBase),bLocale + to_string(__

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread RSmith
On 2014/02/22 00:32, Geo Wil wrote: 1. Windows 7 Ultimate 64-bit 2. Here is the path I am using: void Database::openSave(bool* bErrors) { if (sqlite3_open("*scSave.sqlite*",&dBase) != SQLITE_OK) { *bErrors = true; createBInfo(); d.createBReport("SQL Code 1",

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Geo Wil
I thought of another possible reason why this is going on. The code in question works under one set of circumstances and not under another. If there is no data in my database then I am able to save data. This begged the question "why?" and the answer is because I do not load my data if I start a

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Igor Tandetnik
On 2/21/2014 6:37 PM, Geo Wil wrote: As for the fail path issue, it is not an issue or at least it has never been for me. The way I understand it is that if you just put the file name into a function requesting a path in Windows it will look in the folder the process is running from for that fil

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread RSmith
On 2014/02/22 01:37, Geo Wil wrote: As for the fail path issue, it is not an issue or at least it has never been for me. The way I understand it is that if you just put the file name into a function requesting a path in Windows it will look in the folder the process is running from for that

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Simon Slavin
On 21 Feb 2014, at 9:15pm, Geo Wil wrote: > I checked to see if sqlite3_step was producing an error but it was sending > back a value of 101 or SQLITE_DONE but the table data remained unchanged. Putting this sentence together with the 'Subject' header, it might just be worth reminding you that

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Geo Wil
I got it working finally. There were several problems that were all contributing and it was not until Kees suggested looking at the begins/commits to see if errors were happening that I saw the whole picture. As mentioned in my past response to the thread, the code worked when saving after starti