# sql_statements_log

time_start: 2018-09-05T16:54:12.856Z
time_end: 2018-09-05T16:54:12.955Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT StoredProc_Register('test_proc', 'a Stored Procedure for testing', SqlProc_FromText('SELECT @col1@, $col2$ FROM @table@ WHERE @col2@ LIKE ''@filter@''; SELECT Count(*) FROM @table@;'));


time_start: 2018-09-06T06:54:07.761Z
time_end: 2018-09-06T06:54:07.771Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT * FROM "stored_procedures";
INSERT INTO stored_procedures VALUES ('test_bad', 'an invalid Stored Proc', zeroblob(100))


time_start: 2018-09-06T07:46:32.021Z
time_end: 2018-09-06T07:46:32.034Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT StoredProc_Register('test_loop', 'test loop', SqlProc_FromText('SELECT SqlProc_Return(-1);'))


