Karen,
I see your post fine. I bet your ISP is “blacklisted” and being blocked by
other user’s ISP anti-spam filter. I had to go on mine (not your local e-mail
but the ISP site) and make sure they are added to the safe list. My old ISP,
Twocows was constantly being blacklisted and I finally moved to GoDadddy and I
hardly ever have my e-mails blocked.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
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]>
To: RBASE-L Mailing List <[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
