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 <[email protected]>
To: [email protected]
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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
