Hi Ken,

On Fri, Feb 9, 2024 at 12:23 AM Ken Mankoff via grass-user
<[email protected]> wrote:
>
> Hi Veronica,
>
> On 2024-02-03 at 02:52 +13, Veronica Andreo <[email protected]>
> wrote...
> > Were you able to solve the problem or find its cause? Could you create
> > a reproducible example with the NC dataset? It seems really strange,
> > if the mapset is named vel why would it add the date to it too?
>
> I'm guessing the problem and cause is me, not GRASS. Before I try to 
> replicate in the NC data set, I hope you can help answer a question.
>
> I'm trying to work in multiple mapsets and with multiple tables. I find this 
> hard to do when they're in different databases, so when I create a new mapset 
> I set the DB connection to PERMANENT:
>
> db.connect database=${LOCATION_NAME}/PERMANENT/sqlite/sqlite.db

I believe that the quotes are missing - so the variable is immediately
interpreted.

It is important that it really contains '$GISDBASE' etc. and not the
value of $GISDBASE:

db.connect database='$GISDBASE/$LOCATION_NAME/$MAPSET/vector/$MAP/sqlite.db'

The VAR file then contains

-->
DB_DRIVER: sqlite
DB_DATABASE: $GISDBASE/$LOCATION_NAME/$MAPSET/vector/$MAP/sqlite.db
<--

See
https://grass.osgeo.org/grass-stable/manuals/grass-sqlite.html#connecting-grass-to-sqlite

HTH,
Markus

-- 
Markus Neteler, PhD
https://www.mundialis.de - company
https://grass.osgeo.org - FOSS
https://neteler.org - freelancing & blog
_______________________________________________
grass-user mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/grass-user

Reply via email to