Re: [sqlite] Update fail without ERRORS

2008-03-10 Thread [EMAIL PROTECTED]
SOLVED! Thanks to all and expecially to Dennis I've found MY MISTAKE!!! :-) My head is safe ;-) The error was in my_custom_function. Inside this function I need to query the same table to retrieve some values needed to calculate the float value. Inside my_custom_function I use the prepare

Re: [sqlite] Update fail without ERRORS

2008-03-10 Thread Dennis Cote
[EMAIL PROTECTED] wrote: > I've found what's matter, but I don't understand why ? Can you add the following line to dump the SQL string just before you call sqlite3_exec()? printf("%s\n", zSQL); Now run the program with and without the commented assignment and report the two strings back here.

Re: [sqlite] Update fail without ERRORS

2008-03-10 Thread Dennis Cote
[EMAIL PROTECTED] wrote: > > I don't know where I must crash my head :-( > It looks like the database is fine. Are you certain that you are using the same database file from the command line and in your program? Your program uses the file test.db in the current directory when it runs (unless

Re: [sqlite] Update fail without ERRORS

2008-03-10 Thread [EMAIL PROTECTED]
I've found what's matter, but I don't understand why ? I've tried to use the sqlite3_mprintf() to prepare my sql. If my numeric fValue is integer the SQL works fine, but if I've got a floating value the sql doesn't update the table. And the bad is that I can get any error I'll try to expla

Re: [sqlite] Update fail without ERRORS

2008-03-10 Thread [EMAIL PROTECTED]
>The code looks OK except for the typo (i.e. sPre[2048[ should be > sPre[2048]). Yes, It's a mistype on the mailinglist, the code it's ok! > I assume that your real table isn't named "table" since that is a keyword. The real table name is "inputai" > Can you open the database file using the s

Re: [sqlite] Update fail without ERRORS

2008-03-03 Thread Dennis Cote
[EMAIL PROTECTED] wrote: > > When I execute the code, sqlraw > function print the pSql string, and this is the same I pass. > The > Database descriptor is the same returned from open function, and status > code is OK!!! > > But table value isn't updated. > The code looks OK except for the ty

Re: [sqlite] Update fail without ERRORS

2008-03-01 Thread Neville Franks
Well I'm very new to SQLite but shouldn't: UPDATE table SET Value=12.3 WHERE Address=7 and Port=1 be: UPDATE table SET Value='12.3' WHERE Address='7' and Port='1'; sqlite3_vmprintf() is the recommended method to build SQL with parameters. Saturday, March 1, 2008, 6:31:50 PM, you wrote: tti>

Re: [sqlite] Update fail without ERRORS

2008-03-01 Thread [EMAIL PROTECTED]
The code is very long, I'll try to put here the core of my application. I'm using a C++ Class where one function is "sqlraw" that I use to execute a SQL statement: CLASS DEFINITION sqlite3 *db; int expander:: open_db(char * pDbName) { int rc; rc = sqlite3_open(pDbName,

Re: [sqlite] Update fail without ERRORS

2008-02-29 Thread Dennis Cote
[EMAIL PROTECTED] wrote: > > How can I debug this issu ? > You will have to show some of the code you are having problems with before anyone here can help you with this. Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.

Re: [sqlite] Update fail without ERRORS

2008-02-29 Thread Stephen Oberholtzer
On Fri, Feb 29, 2008 at 11:01 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I'm working on a program using sqlite library, but I've got an issue > that I can't solve. > Suddenly, my program don't update the tables > I > don't understand whats matter because, if I write SQL instructions

[sqlite] Update fail without ERRORS

2008-02-29 Thread [EMAIL PROTECTED]
I'm working on a program using sqlite library, but I've got an issue that I can't solve. Suddenly, my program don't update the tables I don't understand whats matter because, if I write SQL instructions using Sqlite3 client, UPDATE works fine, and I haven't any ERROR CODE. sqlite3_exec funct