search for: retreiev

...y <- select query in SQL sqlCopy(RemoteChannel, query, "LocalTable", destchannel=LocalChannel, safer=TRUE) I am currently getting an error: Error in sqlSave(destchannel, dataset, destination, verbose = verbose, : table 'LocalTable' already exists I need to append the data retreieved through the query, to the table LocalTable. It was my understanding that when safer=TRUE, it would append the new data to an existing table, or create a new table otherwise. This error seems to suggest otherwise. Any ideas? All your help is greatly appreciated! [[alternative HTML version de...

I have a legacy database with which I need to interface. There are two tables that are joined together by two fields, and neither field is the primary key of its associated table. Is constructing an association between these tables beyond the capability of Rails? -- Posted via http://www.ruby-forum.com/.