Yep, either a SQL file run from a shell script or SQL's directly piped into the sqlite3 command, eg:
echo "insert into qgis_gps (stat_code, station_no, point_type, depth, geom) values ('R1A1',2,'s',23, setsrid(makepoint(175.5,-43.5),4326));" | \ sqlite3 -cmd "SELECT load_extension('mod_spatialite');" $DB Thanks... ________________________________ From: Clemens Ladisch <clem...@ladisch.de> To: sqlite-users@mailinglists.sqlite.org Sent: Thursday, January 3, 2019 10:52 PM Subject: Re: [sqlite] sqlite trig/geometry error Brent Wood wrote: > Is there an easy way to tell where the sqlite math functions are coming from? Are you using the sqlite3 command-line shell, or something else? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users