Revision 45008 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.mdb/src/test/resources/org/gvsig/fmap/dal/store/mdb/calculateEnvelope.sql

View differences:

calculateEnvelope.sql
1 1 

  		




  2
  2
  
    
-- Count SQL


  		




  3
  3
  
    
SELECT 


  		




  4
  
  
    
  NVL2(ST_Extent("Geometry"),ST_AsBinary(ST_Extent("Geometry")),NULL) 


  		




  5
  
  
    
  FROM "PUBLIC"."test" 


  		




  6
  
  
    
  WHERE ( ("Geometry") IS NOT NULL );


  		




  
  4
  
    
  [Geometry] 


  		




  
  5
  
    
  FROM [test] 


  		




  
  6
  
    
  WHERE ( ([Geometry]) IS NOT NULL );


  		












Also available in:  Unified diff