Thanks for your reply Igor.

We have used BEGIN and COMMIT while executing our statements.While executing
the BEGIN the return value is 0,but for COMMIT its returning 1.

Please guide us.

Regards,
Farzana.


Igor Tandetnik wrote:
> 
> "hussainfarzana"
> <hussainfarz...@gmail.com> wrote in
> message news:20971588.p...@talk.nabble.com
>> We have developed our application in eVC++ 3.0 using SQLite as the
>> database. While insertion or updation of records
>> We have used BEGIN and COMMIT method to insert or update the records.
>> While running the application we are able to insert and update and we
>> are able to check that value also.Once we exit the application and
>> reopen the application again we are not able to see the values and
>> these records are missing in the database also.The records are
>> inserted or updated temporarily.
> 
> You are executing a BEGIN, but you are _not_ executing a COMMIT. Check 
> your code, figure out why. Without COMMIT, your transaction gets rolled 
> back.
> 
> Igor Tandetnik 
> 
> 
> 
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/COMMIT-in-SQLite-tp20971588p21009480.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Reply via email to