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 HART To: RBASE-L Mailing List 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 Version: 8.0.233 / Virus Database: 270.10.19/1938 - Release Date: 02/04/09 16:35:00
