gvSIG bugs #3608
There's an error in the Filter tool when the text has an apostrophe
| Status: | Closed | % Done: | 0% | |
|---|---|---|---|---|
| Priority: | High | Spent time: | - | |
| Assignee: | - | |||
| Category: | - | |||
| Target version: | 2.5.0-2914 (rev. org.gvsig.desktop-2.0.242) | |||
| Severity: | Major | Add-on version: | ||
| gvSIG version: | 2.2.0 | Add-on build: | ||
| gvSIG build: | 2313 | Add-on resolve version: | ||
| Operative System: | Add-on resolve build: | |||
| Keywords: | Proyecto: | |||
| Has patch: | Hito: | |||
| Add-on name: | Unknown |
Description
When we use the Filter tool in a String field, and the text has an apostrophe it doesn't work, we get an error.
For example:
Comarca= 'L'Alcoia'
It doesn't work even writing two apostrophes:
Comarca= 'L''Alcoia'
Related issues
History
#1
Updated by Mario Carrera almost 9 years ago
- Related to gvSIG bugs #3609: The "?" doesn't work when using the "like" parameter at the Filter tool added
#2
Updated by Francisco Puga almost 9 years ago
In fact is not possible to write a text in the table that contains a single quote (key { ' ? } in spanish keyboard) neither an apostrophe (key { ^ ` } in spanish keyboard).
To reproduce start editing on a table and try to write a text like L'Alcoia. Only 'L' will be written.
#3
Updated by Antonio Falciano almost 9 years ago
Hi all,
the error messages suggest me that the escape character should be backslash:
Comarca = 'L\'Alcoia'but unfortunately it doesn't work as expected here.
Workaround: use the wildcard char for a single char (underscore) in place of the internal single quote. So the example above becomes:
Comarca like 'L_Alcoia'
#4
Updated by Álvaro Anguix about 5 years ago
- Status changed from New to Closed
With the new filter it works fine
#5
Updated by Álvaro Anguix about 5 years ago
- Target version set to 2.5.0-2914 (rev. org.gvsig.desktop-2.0.242)