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

Reply via email to