Just a thought -- is the SQL Server looking in its own table list for
SYS_FORMS3?
Albert
On 5/19/2015 8:48 AM, Lawrence Lustig wrote:
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
--
A democracy ..." can only exist until the majority discovers it can vote itself
largess out of the public treasury."
Attributed to Alexander Fraser Tytler 1747-1813
