Karen, I see Bob’s, Larry’s and your email regularly so I assume none are missing.
Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 O-217-245-9504 F-217-245-2350 [email protected]<mailto:[email protected]> From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Tuesday, May 19, 2015 10:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Messages to the list I know that several people don't see when I post messages to the list, and I know that Bob T and I never see our own posts (he usually asks me to confirm that his posts made it). But apparently I also haven't been seeing Larry Lustig's posts to the list. I just have to hope that someone hopefully answers so I can see the original post. Wish I could figure out what's happening! Doesn't seem to be a common email service address. Karen -----Original Message----- From: Albert Berry <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Tue, May 19, 2015 10:04 am Subject: [RBASE-L] - Re: Using INSERT. . . SELECT on server table. 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
