Uploaded image for project: 'Spatial Information Systems'
  1. Spatial Information Systems
  2. SIS-184

DBase 3 - JDBC : Simple WHERE CLAUSE and Integer, Double field support

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 0.6
    • Shapefile
    • None

    Description

      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.

      Attachments

        1. git_svn.png
          10 kB
          Marc Le Bihan
        2. SIS184_attach_DBase3_driver_to_Squirrel.png
          35 kB
          Marc Le Bihan
        3. SIS184_connect_to_database.png
          22 kB
          Marc Le Bihan
        4. SIS184_create_alias_to_a_dbase3_file.png
          25 kB
          Marc Le Bihan
        5. SIS184_query_the_table.png
          206 kB
          Marc Le Bihan
        6. SIS184_table_metadata.png
          240 kB
          Marc Le Bihan
        7. SIS184_where_statement.png
          190 kB
          Marc Le Bihan
        8. sis-shapefile.zip
          571 kB
          Marc Le Bihan
        9. sis-utility.org.apache.sis.util.logging.zip
          2 kB
          Marc Le Bihan

        Issue Links

          Activity

            People

              mlebihan Marc Le Bihan
              mlebihan Marc Le Bihan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: