[Gvsig_english] Definition query

Antonio Falciano afalciano at yahoo.it
Wed Jan 30 10:25:17 CET 2008 

ernesto sferlazza ha scritto:
> Hi all
> When I work with ESRI ArcMap, often I use the "definition query" that
> allows to use a subset (based on a sql query) of a larger shapefile
> without the need of exporting the same subset in a new shapefile. In

Hi Ernesto, hi all,
a definition query/SQL limitation in the File tab of Add layer dialog
would be very useful especially when we have to manage large vectorial
files! Something of similar seems to be yet implemented (?):
- the "Filter" in Add layer --> tab WFS (imho this is a great function!!)
- the "SQL limitation" in Add layer --> tab GeoBD

About the first one:
http://runas.cap.gva.es/pipermail/gvsig_internacional/2007-September/000790.html

About the second one, when I specify an SQL limitation, gvSIG returns the
following errors:

Error al cargar la capa: ERROR: syntax error at or near "="
com.iver.cit.gvsig.fmap.drivers.DBException: ERROR: syntax error at or
near "="

com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.setData(Unknown
Source)

com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.getLayer(Unknown
Source)
    com.iver.cit.gvsig.AddLayer.loadGenericWizardPanelLayers(Unknown
Source)     com.iver.cit.gvsig.AddLayer.addLayers(Unknown Source)
    com.iver.cit.gvsig.AddLayer.execute(Unknown Source)

com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:88)
    com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:616)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)     java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)

com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source) Error al cargar la
capa: ERROR: syntax error at or near "="
com.iver.cit.gvsig.fmap.drivers.DBException: ERROR: syntax error at or
near "="

com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.setData(Unknown
Source)

com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.getLayer(Unknown
Source)
    com.iver.cit.gvsig.AddLayer.loadGenericWizardPanelLayers(Unknown
Source)     com.iver.cit.gvsig.AddLayer.addLayers(Unknown Source)
    com.iver.cit.gvsig.AddLayer.execute(Unknown Source)

com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:88)
    com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:616)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)     java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)

com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source) Error al cargar la
capa: ERROR: syntax error at or near "="
com.iver.cit.gvsig.fmap.drivers.DBException: ERROR: syntax error at or
near "="

com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.setData(Unknown
Source)

com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.getLayer(Unknown
Source)
    com.iver.cit.gvsig.AddLayer.loadGenericWizardPanelLayers(Unknown
Source)     com.iver.cit.gvsig.AddLayer.addLayers(Unknown Source)
    com.iver.cit.gvsig.AddLayer.execute(Unknown Source)

com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:88)
    com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:616)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)     java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)

com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source) Error al cargar la
capa: ERROR: syntax error at or near "="
com.iver.cit.gvsig.fmap.drivers.DBException: ERROR: syntax error at or
near "="

com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.setData(Unknown
Source)

com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.getLayer(Unknown
Source)
    com.iver.cit.gvsig.AddLayer.loadGenericWizardPanelLayers(Unknown
Source)     com.iver.cit.gvsig.AddLayer.addLayers(Unknown Source)
    com.iver.cit.gvsig.AddLayer.execute(Unknown Source)

com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:88)
    com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:616)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)     java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)

com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source)

Best Regards,
Antonio

More information about the Gvsig_internacional mailing list