hi,
i have a sqlite database, which holds two tables:
- roads_1 (cat, ... some other columns ...)
- roads_2 (cat column only)
first table contains about 32000 rows. second one contains about 1400
rows and was populated from roads_1.cat column using SQL query.
i have `roads` vector map with layers
$ v.db.connect -p map=roads
Vector map <roads> is connected by:
layer <1> table <roads_1> in database <sqlite.db> through driver <sqlite> with key <cat>
layer <2> table <roads_2> in database <sqlite.db> through driver <sqlite> with key <cat>
the second layer was created using command
$ v.db.connect --v -o map=roads database=sqlite.db key=cat layer=2 table=roads_2
displaying first layer, i.e. using command
$ d.vect map=roads layer=1
but when i want to display second layer, then nothing is displayed.
even more
$ v.category input=roads layer=1 option=print | wc -l
37275
$ v.category input=roads layer=2 option=print | wc -l
0
but table `roads_2` contains more than 1400 categories.
looking at v.db.connect it does not seem that i should perform more
operations... but probably i am missing something here.
regards,
wrobell <wrobell@pld-linux.org>