SQLite Forum

Finding next ; in multi-statement SQL
Login

Finding next ; in multi-statement SQL

(1) By Paul van Helden (paulvh) on 2020-05-15 01:58:20 [source]

Hi,

sqlite3_prepare yields a pointer to the next statement through pzTail
sqlite3_complete finds the terminating ; (and skips ; inside a CREATE TRIGGER)

What I need is the location of the ; before preparing, e.g. if sqlite3_complete returned the position of the ; instead of 1 if it is present. Even better would be a pointer to the next statement (after skipping comments).

Is this possible without writing my own parser? If not, please accept it as a request.

Thanks,

Paul.