Determine If An SQL Statement Is Complete
int sqlite3_complete(const char *sql);
int sqlite3_complete16(const void *sql);
These routines are useful during command-line input to determine if the 
currently entered text seems to form a complete SQL statement or if additional 
input is needed before sending the text into SQLite for parsing. These routines 
return 1 if the input string appears to be a complete SQL statement. A 
statement is judged to be complete if it ends with a semicolon token and is not 
a prefix of a well-formed CREATE TRIGGER statement.

sqlite3_complete(“x”) returns false but sqlite3_complete(“x;”) doesn’t because 
it has a semi-colon at the end.

It checks the input is appended with a semi-colon? Surely I’m missing something?


Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to