Statistics
| Revision:

svn-gvsig-desktop / 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 / append.sql @ 44916

History | View | Annotate | Download (425 Bytes)

1 

    		
  

  

    
      2
    
    
      
-- Previous SQLs


    		
  

  

    
      3
    
    
      
SET LOG 1;


    		
  

  

    
      4
    
    
      
SET LOCK_MODE 1;


    		
  

  

    
      5
    
    
      
SET UNDO_LOG 0;


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
-- Inser SQL


    		
  

  

    
      8
    
    
      
INSERT INTO "PUBLIC"."test" ( 


    		
  

  

    
      9
    
    
      
    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 


    		
  

  

    
      10
    
    
      
    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", 


    		
  

  

    
      11
    
    
      
    "Decimal", "Geometry" 


    		
  

  

    
      12
    
    
      
  ) 


    		
  

  

    
      13
    
    
      
  VALUES ( 


    		
  

  

    
      14
    
    
      
     ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ST_GeomFromWKB((?), (?)) 


    		
  

  

    
      15
    
    
      
  );


    		
  

  

    
      16
    
    
      

    		
  

  

    
      17
    
    
      
-- Post SQLs


    		
  

  

    
      18
    
    
      
SET LOG 2;


    		
  

  

    
      19
    
    
      
SET LOCK_MODE 3;


    		
  

  

    
      20
    
    
      
SET UNDO_LOG 1;