I've created a test table in SQL Server database like this: CREATE TABLE TestData ( IntColumn INTEGER) and attached it to my RBase 9.5 / 64 database like this: SATTACH dbo.TestData as SVRTestData USING InvColumn
I can then issue the command INSERT INTO SVRTestData (IntColumn) VALUES (10) and the value 10 is correctly inserted into the server database. However, when I issue the command INSERT INTO SVRTestData (IntColumn) SELECT 10 FROM SYS_FORMS3 WHERE LIMIT = 1 which should do exactly the same thing, I get the error Resources required by the command are not available. What do I need to do in order to insert data from an R:Base table into a server table (and, of course, vice-versa). My goal is to pump rather substantial number of records back and forth; this is just the simplest case I could create. --Larry
