[GRASSLIST:151] Re: Creating vector from MySQL database (GRASS 6.1)

[Stephan Holl]

Hello Rainer,

On Wed, 15 Mar 2006 13:51:25 +0200 Rainer M Krug <rkrug at sun.ac.za>
wrote:

> Thanks, but Ho difference - empty vector layer and "Segmentation
> fault"
Another thing I could imagine is the key-column beginning with an
underscore. Do you have the possibility to temporary create another
ID-column inside your data-table (perhaps use the OID-column if
present?) to see if that is a problem?

Best

	Stephan

> 
> Rainer
> 
> 
> 
> Stephan Holl wrote:
> > Hello Rainer,
> > 
> > On Wed, 15 Mar 2006 12:22:22 +0200 Rainer M Krug <rkrug at sun.ac.za>
> > wrote:
> > 
> >> When I execute
> >>
> >> v.in.db driver=mysql
> >> database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
> >> table=def_renosterbos x=X y=Y z=RX key=_ID 'where=(_RUN = 5) AND
> >> (_YEAR=99)' output=def_renosterbos_run_5_year_99_2
> >>
> >> I get a Segmentation fault and an empty vector layer is created -
> >> am I doing something wrong or is it a bug?
> > 
> > Untested: 
> > use your quotes slightly different:
> > v.in.db driver=mysql
> > database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
> > table=def_renosterbos x=X y=Y z=RX key=_ID where="(_RUN = 5) AND
> > (_YEAR=99)" output=def_renosterbos_run_5_year_99_2
> > 
> > Perhaps this helps.
> > 
> > 	Stephan
> > 
> > 
> > 
> 
> 



-- 
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office      -     Mengendamm 16d      -     D-30177 Hannover
Internet: www.gdf-hannover.de      -      Email: holl at gdf-hannover.de
Phone : ++49-(0)511.39088507       -        Fax: ++49-(0)511.39088508