logo       

Re: [sqlite] DELETE ststement not working as expected: msg#00862

sqlite-users

Subject: Re: [sqlite] DELETE ststement not working as expected

Thanks Shane, but I do not believe that is the issue. I bind these values
in my INSERT statements and it works fine. Otherwise I wouldn't have a
DELETE problem, would I? ;) Also, the values are acceptable if I try my
DELETE at the SQLite command prompt.

-----Original Message-----
From: sqlite-users-bounces@xxxxxxxxxx
[mailto:sqlite-users-bounces@xxxxxxxxxx] On Behalf Of Shane Harrelson
Sent: Thursday, July 30, 2009 3:31 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] DELETE ststement not working as expected

I believe sqlite3_bind_int64() takes a signed int for the value to bind.
You state you are passing it a large unsigned int. If the unsigned value
is large enough, it will appear to be a negative signed int.

HTH.
-Shane
_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | Mail Home | sitemap | FAQ | advertise