Re: [sqlite] Any way to make xUpdate only alter the columns that are changed?

2010-07-28 Thread Ben Harper
: Re: [sqlite] Any way to make xUpdate only alter the columns that are changed? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2010 07:37 AM, Ben Harper wrote: > then it would be great if the xUpdate function could inform one that only the > field 'age' is being alter

Re: [sqlite] Any way to make xUpdate only alter the columns that are changed?

2010-07-28 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2010 07:37 AM, Ben Harper wrote: > then it would be great if the xUpdate function could inform one that only the > field 'age' is being altered. As it is now, every field is fed to xUpdate, > causing a circumventable read/verify/write burden

[sqlite] Any way to make xUpdate only alter the columns that are changed?

2010-07-28 Thread Ben Harper
It seems apparent from the docs (and the function headers) that there is no way to cause Sqlite's Virtual Table xUpdate function to notify the implementation of the exact fields that were altered. For example, if I do UPDATE people SET age=40 WHERE name='jim' then it would be great if the xUpda