[GRASS-dev] attribute table manager; SQL Builder; SQL statement is not valid.

[Margherita Di Leo]

Hi,

thank you Maris.
Would it be possible to grey out the "verify" and "apply" buttons before
the comparison operator has been selected? This would be more intuitive.

Thanks
madi

On Tue, Jan 22, 2013 at 7:55 AM, Maris Nartiss <maris.gis at gmail.com> wrote:

> Hi,
> before pressing "Verify", You must enter comparison operator. = or LIKE
>
> Maris.
>
> 2013/1/21 Margherita Di Leo <dileomargherita at gmail.com>:
> > Hi,
> >
> > I'm using GRASS 6.4.3svn on Red Hat. Trying to use the SQL Builder, I
> always
> > obtain Syntax Error on queries which are self built by the builder...
> > Example on NC dataset:
> > map: census_wake2000
> > I open the attribute table manager from the GUI
> > I select: SQL Query: Advanced
> > Columns: TRT2000 -> Get sample -> Value: 050100 (the first on the top) ->
> > Verify
> > I get:
> >
> > SQL statement is not valid.
> >
> > DBMI-DBF driver error:
> > SQL parser error: syntax error, unexpected STRING processing ''050100' '
> > in statement:
> > SELECT * FROM census_wake2000 WHERE TRT2000 '050100'
> > Error in db_open_select_cursor()
> >
> > ?
> >
> > Thanks,
> > madi
> >
> > --
> > Margherita DI LEO
> > Postdoctoral Researcher
> >
> > European Commission - DG JRC
> > Institute for Environment and Sustainability (IES). Unit H03 – FRC
> > Via Fermi, 2749
> > I-21027 Ispra (VA) - Italy - TP 261
> >
> > Tel. +39 0332 78 3600
> > margherita.di-leo at jrc.ec.europa.eu
> >
> > Disclaimer: The views expressed are purely those of the writer and may
> not
> > in any circumstance be regarded as stating an official position of the
> > European Commission.
> >
> > _______________________________________________
> > grass-dev mailing list
> > grass-dev at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/grass-dev
>



-- 
Margherita DI LEO
Postdoctoral Researcher

European Commission - DG JRC
Institute for Environment and Sustainability (IES). Unit H03 – FRC
Via Fermi, 2749
I-21027 Ispra (VA) - Italy - TP 261

Tel. +39 0332 78 3600
margherita.di-leo at jrc.ec.europa.eu

Disclaimer: The views expressed are purely those of the writer and may not
in any circumstance be regarded as stating an official position of the
European Commission.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20130122/286953cb/attachment.html>