Re: [sqlite] Prepared Statement Consistency

2019-08-19 Thread Simon Slavin
On 19 Aug 2019, at 11:22pm, Mitchell Keith Bloch wrote: > I have observed that preparing statements that depend on a table will fail if > the table does not currently exist. It appears that those prepared statements > will, however, continue to function if the table is dropped and subsequently

Re: [sqlite] Prepared Statement Consistency

2019-08-19 Thread Richard Hipp
On 8/19/19, Mitchell Keith Bloch wrote: > I have observed that preparing statements that depend on a table will fail > if the table does not currently exist. It appears that those prepared > statements will, however, continue to function if the table is dropped and > subsequently recreated. Will

[sqlite] Prepared Statement Consistency

2019-08-19 Thread Mitchell Keith Bloch
I have observed that preparing statements that depend on a table will fail if the table does not currently exist. It appears that those prepared statements will, however, continue to function if the table is dropped and subsequently recreated. Will I find this behavior to be consistent if I later