Revision 44951 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/fetchFeatureProviderByReference.sql

View differences:

fetchFeatureProviderByReference.sql
1 1 

  		




  2
  2
  
    
-- Count SQL


  		




  3
  3
  
    
SELECT 


  		




  4
  
  
    
  "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 


  		




  5
  
  
    
  "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 


  		




  6
  
  
    
  NVL2("Geometry",ST_AsBinary("Geometry"),NULL) 


  		




  7
  
  
    
  FROM "PUBLIC"."test" 


  		




  8
  
  
    
  WHERE ( ("ID") = (?) ) LIMIT 1;


  		




  
  4
  
    
  [ID], [Byte], [Bool1], [Long], [Timestamp], [Date], [Time], [Bool2], 


  		




  
  5
  
    
  [String], [Bool3], [Double], [Bool4], [Float], [Bool5], [Decimal], 


  		




  
  6
  
    
  [Geometry], [Decimal19_0] 


  		




  
  7
  
    
  FROM [test] 


  		




  
  8
  
    
  WHERE ( ([ID]) = (?) ) LIMIT 1;


  		












Also available in:  Unified diff