Re: [sqlite] Getting all changes within a begin; end; transaction

2020-03-04 Thread Jose Isaias Cabrera 

Simon Slavin, on Wednesday, March 4, 2020 10:47 AM, wrote...
>
> On 4 Mar 2020, at 3:28pm, Jose Isaias Cabrera  wrote:
>
> > The reason why I know is that if I have 238 INSERTS, but I have a
> constraint , there should be 238 INSERTs the first time I run a set of SQL,
> but if I run the same SQL again, there should not be any records INSERTED,
> and thus, the amount should be 0, correct?
>
> Can you try the same thing but instead of INSERT use INSERT OR IGNORE ?

Simon Slavin, you are a genius!  Well, you're pretty smart. ;-)  Yes, indeed, I 
was using
INSERT OR REPLACE, which will always work. ;-)  INSERT OR IGNORE is now 
providing
the result I am looking for.  As we say in Spanish, muchas gracias.

josé
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting all changes within a begin; end; transaction

2020-03-04 Thread Simon Slavin 
On 4 Mar 2020, at 3:28pm, Jose Isaias Cabrera  wrote:

> The reason why I know is that if I have 238 INSERTS, but I have a constraint 
> , there should be 238 INSERTs the first time I run a set of SQL, but if I run 
> the same SQL again, there should not be any records INSERTED, and thus, the 
> amount should be 0, correct?

Can you try the same thing but instead of INSERT use INSERT OR IGNORE ?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting all changes within a begin; end; transaction

2020-03-04 Thread Simon Slavin 
On 4 Mar 2020, at 3:28pm, Jose Isaias Cabrera  wrote:

> However, I have found that it does not actually provide the **ACTUAL** 
> changes, but a count of the possible changes.

Hmm.  I understand you.  Does this do something more like what you need ?


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting all changes within a begin; end; transaction

2020-03-04 Thread Jose Isaias Cabrera 

Simon Slavin, on Wednesday, March 4, 2020 09:42 AM, wrote...
>
> On 4 Mar 2020, at 2:37pm, Jose Isaias Cabrera  wrote:
>
> > Is there a way to know all the changes that may have happened within
> the full BEGIN and END? Thanks.
>
> Use this function
>
> 
>
> before and after your block, and subtract one from another.

Thanks, this is exactly what I needed.  However, I have found that it does not 
actually provide the **ACTUAL** changes, but a count of the possible changes.  
The reason why I know is that if I have 238 INSERTS, but I have a constraint , 
there should be 238 INSERTs the first time I run a set of SQL, but if I run the 
same SQL again, there should not be any records INSERTED, and thus, the amount 
should be 0, correct?  So, is there one that actually provides the actual 
number of changes?  Thanks.

josé
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting all changes within a begin; end; transaction

2020-03-04 Thread Simon Slavin 
On 4 Mar 2020, at 2:37pm, Jose Isaias Cabrera  wrote:

> Is there a way to know all the changes that may have happened within the full 
> BEGIN and END?  Thanks.

Use this function



before and after your block, and subtract one from another.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users