Have you troubled yourself with putting a "pause for 2" or some value upward
of that, between the commands to ascertain if it is a timing issue?
Since this is done through the ODBC driver, I am uncertain when control is
relinquished to RBase for the next command.
----- Original Message -----
From: "Dan Goldberg" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, February 09, 2009 3:00 PM
Subject: [RBASE-L] - Re: Sconnect revisited
I would report it as a bug. I have seen this before but also found a
workaround.
Dan Goldberg
_____
From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART
Sent: Sunday, February 08, 2009 6:41 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Sconnect revisited
Here is what I'm doing:
project temptableA from tableB
project temptableB from tableA
inserting temptableA into tableA
inserting temptableB into tableB ----it hangs up right here, I get disk
error and pointer error, have to kill with task manager
if I do it this way
project temptableA from tableB
inserting temptableA into tableA
drop temptableA
project temptableB from tableA
inserting temptableB into tableB
drop temptableB
this works, I know it is not a syntax problem because I am just copying
and
pasting
_____
From: Alastair Burr <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Sunday, February 8, 2009 2:23:05 AM
Subject: [RBASE-L] - Re: Sconnect revisited
Tom,
Is your error on the second project or the next command? I projected two
temp tables at the R:> with no problem using a single line command with a
;
separator.
Just another thought: are you using the "USING *" syntax or specifying
some
columns?
Regards,
Alastair.
----- Original Message -----
From: TOM <mailto:[email protected]> HART
To: RBASE-L Mailing List <mailto:[email protected]>
Sent: Sunday, February 08, 2009 1:20 AM
Subject: [RBASE-L] - Re: Sconnect revisited
The table names are not the problem, I just did that for example. The
situation is that if I try to project the 2 temptables(with different
names)
at the same time the the process fails.
Tom
_____
From: Alastair Burr <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Saturday, February 7, 2009 6:57:59 PM
Subject: [RBASE-L] - Re: Sconnect revisited
Table names not distinct in the first 8 characters?
Regards,
Alastair.
----- Original Message -----
From: TOM <mailto:[email protected]> HART
To: RBASE-L Mailing List <mailto:[email protected]>
Sent: Saturday, February 07, 2009 7:45 PM
Subject: [RBASE-L] - Sconnect revisited
First of all I corrected the scratch settings as per Razz.
The problem I seem to run into, but is easy to work around is this
I am trying to update(or sync) 2 identical databases with data from a
table,
and this scenario does not work:
Connected: DatabaseA, Table: TableA
sConnected: DatabaseB, sAttached Table: TableA as alias TableB
To update the data I am projecting a temp tableA from TableB where data
does
not exist, and inserting it into TableA
Then projecting a tempB table from TableA and inserting it into TableB
if I try to create both temp tables in consecutive order, the process
fails
- I get error disk problem
however if I create tempA, do the process, drop tempA, create tempB and do
process everything works
drop TempTableA
drop TempTableB
project temp TempTableA from TableB where......
project temp TempTableB from TableA where......
do my updating
this will fail
however
drop TempTableA
project temp TempTableA from TableB where......
do my updating
drop TempTableA
drop TempTableB
project temp TempTableB from TableA where......
do my updating
drop TempTableB
this will work
The work-around is simple but why will the first scenario not work.
Tom
_____
No virus found in this incoming message.
Checked by AVG - www.avg.com <http://www.avg.com/>
Version: 8.0.233 / Virus Database: 270.10.19/1938 - Release Date: 02/04/09
16:35:00
_____
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.19/1939 - Release Date: 02/06/09
17:28:00
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
