Re: [sqlite] Update problem in use C/C++ interface

2010-03-26 Thread Pavel Ivanov
> and i'm sure there is a record with the ID bind for the third parameter. You should be also sure that this record contains ID as an integer value, not as text value. Without affinity integer will never be equal to text. Pavel 2010/3/24 王志刚 : > ??? wrote: >> Hi, I meet a problem in use c/c++ A

Re: [sqlite] Update problem in use C/C++ interface

2010-03-24 Thread 王志刚
??? wrote: > Hi, I meet a problem in use c/c++ API to update a row in table. > all return value means the operate is successful, But the row have no > change at all. How do you determine this? > the main code al follow: > >wstring sql = L"UPDATE Mail SET [Content] = ?1 [CurrentSize] = ?2 > WH

Re: [sqlite] Update problem in use C/C++ interface

2010-03-24 Thread Igor Tandetnik
王志刚 wrote: > Hi, I meet a problem in use c/c++ API to update a row in table. > all return value means the operate is successful, But the row have no > change at all. How do you determine this? > the main code al follow: > >wstring sql = L"UPDATE Mail SET [Content] = ?1 [CurrentSize] = ?2 > W

[sqlite] Update problem in use C/C++ interface

2010-03-24 Thread 王志刚
Hi, I meet a problem in use c/c++ API to update a row in table. all return value means the operate is successful, But the row have no change at all. and the INSERT , SELECT operation is OK. I think maybe I'm not first one meet this problem.But I can't visit the archive. So if anyone here know abou