Draft Documentation small fixes

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Draft Documentation small fixes

R Smith-2
In the paragraph explaining: SQLITE_FCNTL_DATA_VERSION found here:
https://www.sqlite.org/draft/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion

(Suggested edits indicated like *this*)

...// The sqlite3_total_changes()
<https://www.sqlite.org/draft/c3ref/total_changes.html> interface can be
used to find if any database on the connection has changed, but that
interface respon*ds* to changes on TEMP as well as MAIN and does not
provide a mechanism to detect changes to MAIN only. Also, the
sqlite3_total_changes()
<https://www.sqlite.org/draft/c3ref/total_changes.html> interface
respon*ds* to internal changes only and omits changes made by other
database connections. The PRAGMA data_version
<https://www.sqlite.org/draft/pragma.html#pragma_data_version> command
provide*s* a mechanism to detect changes to a single attached database
that occur due to other database connections, but omits changes
implemented by the database connection for which it is called. This file
control is the only mechanism to detect changes that happen either
internally or externally*,* on a single database.

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Draft Documentation small fixes

Richard Hipp-3
Tnx for the report.  Fixed now.

On 9/12/18, R Smith <[hidden email]> wrote:

> In the paragraph explaining: SQLITE_FCNTL_DATA_VERSION found here:
> https://www.sqlite.org/draft/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion
>
> (Suggested edits indicated like *this*)
>
> ...// The sqlite3_total_changes()
> <https://www.sqlite.org/draft/c3ref/total_changes.html> interface can be
> used to find if any database on the connection has changed, but that
> interface respon*ds* to changes on TEMP as well as MAIN and does not
> provide a mechanism to detect changes to MAIN only. Also, the
> sqlite3_total_changes()
> <https://www.sqlite.org/draft/c3ref/total_changes.html> interface
> respon*ds* to internal changes only and omits changes made by other
> database connections. The PRAGMA data_version
> <https://www.sqlite.org/draft/pragma.html#pragma_data_version> command
> provide*s* a mechanism to detect changes to a single attached database
> that occur due to other database connections, but omits changes
> implemented by the database connection for which it is called. This file
> control is the only mechanism to detect changes that happen either
> internally or externally*,* on a single database.
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users