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
[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.
[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
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
>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
[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
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>
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,
[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.
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
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
11 matches
Mail list logo
