Re: [sqlite] Differentiate between an empty result set and an error using Python3

2019-09-04 Thread Keith Medcalf
>Possibly the Python documentation is overwhelming here as data can also be >retrieved with explicit fetch steps. The APSW documentation is better. The sqlite3 documentation is somewhat limited. >>> import sqlite3 >>> db = sqlite3.connect('', isolation_level=None) # isolation_level=None turns

Re: [sqlite] Differentiate between an empty result set and an error using Python3

2019-09-04 Thread E.Pasma
> Op 5 sep. 2019, om 00:10 heeft Keith Medcalf het > volgende geschreven: > > > On Wednesday, 4 September, 2019 12:18, Rob Sciuk wrote: > >> Forgive me if this is an FAQ, but in looking over the python3 interface to >> SQLITE3, I cannot see a way to get the result code (SQLITE_OK) after an

Re: [sqlite] Differentiate between an empty result set and an error using Python3

2019-09-04 Thread Keith Medcalf
On Wednesday, 4 September, 2019 12:18, Rob Sciuk wrote: >Forgive me if this is an FAQ, but in looking over the python3 interface to >SQLITE3, I cannot see a way to get the result code (SQLITE_OK) after an >execute() command. >My use case is to differentiate between an empty row set (OK) vs an

Re: [sqlite] Differentiate between an empty result set and an error using Python3

2019-09-04 Thread David Raymond
Sent: Wednesday, September 04, 2019 2:18 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Differentiate between an empty result set and an error using Python3 Forgive me if this is an FAQ, but in looking over the python3 interface to SQLITE3, I cannot see a way to get the result code

[sqlite] Differentiate between an empty result set and an error using Python3

2019-09-04 Thread Rob Sciuk
Forgive me if this is an FAQ, but in looking over the python3 interface to SQLITE3, I cannot see a way to get the result code (SQLITE_OK) after an execute() command. My use case is to differentiate between an empty row set (OK) vs an error of some kind in the query. Anyone figured this