Re: [sqlite] [EXTERNAL] Number of changes

2018-12-05 Thread Hick Gunter
values will be 2. Von: Prajeesh Prakash [mailto:prajeeshprakash@elear.solutions] Gesendet: Mittwoch, 05. Dezember 2018 14:04 An: Hick Gunter Betreff: Re: AW: [sqlite] [EXTERNAL] Number of changes I ma trying to two insert on a single sqlite3_exec() eg: char *url = ""BEGIN TRANSACTION;&q

Re: [sqlite] [EXTERNAL] Number of changes

2018-12-05 Thread Prajeesh Prakash
Thank you i tried sqlite3_changes() but in that case i INSERT 2 rows but it gave 1. > > On December 5, 2018 at 5:51 PM Hick Gunter wrote: > > RTM. > > Sqlite3_total_changes() counts the *total* number of changes done since > the connection was opened. To get the number of change

Re: [sqlite] [EXTERNAL] Number of changes

2018-12-05 Thread Hick Gunter
RTM. Sqlite3_total_changes() counts the *total* number of changes done since the connection was opened. To get the number of changes made by the *last statement*, use sqlite3_changes(). This applies only to connections that are not shared between threads. -Ursprüngliche Nachricht- Von: