The .param commands seem to have difficulty with the SQLITE_DEFAULT_DEFENSIVE.  
If you define it as in #define SQLITE_DEFAULT_DEFENSIVE (to either 1 or 0) then 
the .param init does not create the temp.sqlite_parameters table.  pragma 
trusted_schema=1; then allows the .param init to work, but you cannot set 
parameter values.

If SQLITE_DEFAULT_DEFENSIVE is undefined, then .param works normally even after 
pragma trusted_schema=0;

-- 
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.




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

Reply via email to