[ https://issues.apache.org/jira/browse/SIS-184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14194232#comment-14194232 ]
M. Le Bihan commented on SIS-184: --------------------------------- The JDBC objects implement enough methods to allow [Squirrel SQL|http://squirrel-sql.sourceforge.net/] to be used to query data from a DBF file. *1)* Open Squirrel SQL, and declare a Driver for DBase 3 using _"create a new Driver"_ button in the Drivers tab. !SIS184_attach_DBase3_driver_to_Squirrel.png! *2)* Create an alias to the database you want to query, by the _"create a new Alias"_ button in the Aliases tab !SIS184_create_alias_to_a_dbase3_file.png! and connect to it : !SIS184_connect_to_database.png! (no need to use a user/password) *3)* Query the table : At the time this comment is put the table name checking is in progress : you can put the name you want : a _SELECT * FROM <the only table contained in DBF>_ will always be executed. !SIS184_query_the_table.png! > DBase 3 - JDBC : Simple WHERE CLAUSE and Integer, Double field support > ---------------------------------------------------------------------- > > Key: SIS-184 > URL: https://issues.apache.org/jira/browse/SIS-184 > Project: Spatial Information Systems > Issue Type: Improvement > Components: Features, Storage > Affects Versions: 0.5 > Reporter: M. Le Bihan > Priority: Minor > Attachments: SIS184_attach_DBase3_driver_to_Squirrel.png, > SIS184_connect_to_database.png, SIS184_create_alias_to_a_dbase3_file.png, > SIS184_query_the_table.png > > > Following the SIS-180 (select * from DBF) this improvment will add the > ability to : > * Obtain field values from Integer and Double fields. > * Add a simple WHERE clause with = , >, <, >=, <=, <> operators. > Relational operators (AND, OR) _might be_ implemented too, depending on the > ability of parsing the query easily or not. Else, this feature will come in > another JIRA. -- This message was sent by Atlassian JIRA (v6.3.4#6332)