Dear users...
I'm working on a debian testing....and grass57
I have got a problem:
I connected grass57 with mysql:
db.connect driver=mysql database=tezio -p
and after I connected vector attribute to the same db:
v.database driver=mysql database=tezio -p
after this, I started v.digit and I created a new table using "settings
-> table"
the table was succesfully created!!!
later, I started to digitize. When I stopped a window appeared saying:
New record was created.
Cannot open select cursor:
'select * from sentieri where cat = 1'
on database 'tezio' by driver 'mysql'
and on the v.digit panel I obtained this:
dbmi: Protocol error
WARNING: Cannot open select cursor
I'm doing something wrong???
thank you very much for your attention!!!!
Ivan
The record was created or not (mysql, db.select)?
Radim
On Friday 16 July 2004 11:37, ivan marchesini wrote:
Dear users...
I'm working on a debian testing....and grass57
I have got a problem:
I connected grass57 with mysql:
db.connect driver=mysql database=tezio -p
and after I connected vector attribute to the same db:
v.database driver=mysql database=tezio -p
after this, I started v.digit and I created a new table using "settings
-> table"
the table was succesfully created!!!
later, I started to digitize. When I stopped a window appeared saying:
New record was created.
Cannot open select cursor:
'select * from sentieri where cat = 1'
on database 'tezio' by driver 'mysql'
and on the v.digit panel I obtained this:
dbmi: Protocol error
WARNING: Cannot open select cursor
I'm doing something wrong???
thank you very much for your attention!!!!
Ivan
Hi Radim
this is the answer....:
echo "select * from sentieri where cat = 1" | db.select
dbmi: Protocol error
it doesn't work...
but I tried to use postgreSQL and in this case I had not problems...
with postgreSQL, in fact, I can make a table without problems... and I
can insert attributes too....
with postgreSQL all is fine... but I would want to use mysql.... 
thanks....
ivan
Il ven, 2004-07-16 alle 11:37, ivan marchesini ha scritto:
Dear users...
I'm working on a debian testing....and grass57
I have got a problem:
I connected grass57 with mysql:
db.connect driver=mysql database=tezio -p
and after I connected vector attribute to the same db:
v.database driver=mysql database=tezio -p
after this, I started v.digit and I created a new table using "settings
-> table"
the table was succesfully created!!!
later, I started to digitize. When I stopped a window appeared saying:
New record was created.
Cannot open select cursor:
'select * from sentieri where cat = 1'
on database 'tezio' by driver 'mysql'
and on the v.digit panel I obtained this:
dbmi: Protocol error
WARNING: Cannot open select cursor
I'm doing something wrong???
thank you very much for your attention!!!!
Ivan