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

[Margherita Di Leo]

And .. I'd have another wish (pls don't kill me)
It would be nice if the features selected from the attribute table were
highlighted (for example using a different color, i.e. yellow) in the Map
Display.

Thanks
madi

On Tue, Jan 22, 2013 at 9:39 AM, Margherita Di Leo <
dileomargherita at gmail.com> wrote:

> 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.
>



-- 
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/59c016ea/attachment-0001.html>