[R] Custom Command to Generate SQL

Alex Restrepo alex_restrepo at hotmail.com
Mon Jun 19 07:03:48 CEST 2006


I would like to create a custom command in R which generates SQL, which is 
then processed via RODBC.

For example, the user would type:

        retrieve firstName('JOHN') middlleName('WILLIAMS') lastName('FORD')

This would generate the following SQL which would then be processed by 

Select *
  from people
  where firstName = 'JOHN' and
            middleName = 'WILLIAMS' and
            lastName     = 'FORD'

Does anyone have a recommendation?  Any ideas would be greatly appreciated.


More information about the R-help mailing list