Skip to content
Prev 164716 / 398506 Next

Avoiding multiple outputs using RODBC package

Mark Wardle 
Hi.

You don't need to download the whole of the output database table to
look for an already generated answer. You can write a SQL query to do
that instead. ie. give me any rows with these parameters...  Get the
database to do the work - it is what they are designed to do.

So the procedure is:

1. Get input parameters
2. Query the output database to see whether analysis has already been
done (select * from output_table where...)
3. If not already done, do the calculation and insert result into output table

Note: you don't have to use sqlSave to save data. One can add single
rows by running arbitrary SQL.

Mark

2008/12/12 Brigid Mooney <bkmooney at gmail.com>:

  
    

      
      
    

  


  


  


  
  

    

  

    
      
    
    
Thread (3 messages)

  

  

    
            
        Brigid Mooney
        
        Avoiding multiple outputs using RODBC package
      
      Dec 12
    
    
      
            
        Mark Wardle
        
        Avoiding multiple outputs using RODBC package
      
      Dec 14
    
    
      
            
        Brian Ripley
        
        Avoiding multiple outputs using RODBC package
      
      Dec 15