[Gvsig_english] Sql language in the shapefile filter

[Pablo Piqueras Bartolomé]

silvio grosso escribió:
> Hello everybody, 
>
> I am wondering if is it possible to write some simple query in the filter using the SQL language?
>
> I read gvSIG's manual but I didn't find any example about that.
> At present , to select an area I should write: TOPONIMO = 'ASTI' in order to get the selection.
> Nevertheless, in some cases SQL language is faster.
> For example, when I want to select  two areas in a shapefileI am obliged to write two times the word TOPONIMO (e.g TOPONIMO = 'ASTI' or TOPONIMO =  'Aglie'). 
> When I want to select four or more TOPONIMOS in the filter it becomes complicated.
>
> Best regards
>
> Silvio
>
>
>       ___________________________________ 
> Scopri il Blog di Yahoo! Mail: trucchi, novità, consigli... e la tua opinione!
> http://www.ymailblogit.com/blog/
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>
>
>   
Hello Silvio,

I'm supposing the filter you're talking about is the associated one to 
the table of a vectorial layer. If not, I'll probably can't reply your 
question.

The expression you can write there is an subset of SQL, the part of the 
"WHERE". I think it was made thus to be compatible with other old 
subsystems in gvSIG.

You can try other SQL sentences, anyway, some of them could run.

For instance: TOPONIMO like 'A%'

It's probably that in the future, gvSIG could support more complex SQL 
sentences.


Regards.

-- 
Pablo Piqueras Bartolomé

Equipo de gvSIG
IVER T.I. S.A.
C/. Lérida, 20
46005 - Valencia (Spain)
www.iver.es
www.gvsig.com


Este mensaje y sus archivos son confidenciales. No está permitida su reproducción o distribución sin la autorización expresa de "IVER Tecnologías de la Información". Si usted no es el destinatario previsto, queda desautorizado cualquier uso, acceso o copia de este mensaje. Si ha recibido este mensaje por error, por favor bórrelo e infórmenos por esta misma vía.