Tom,
>>> What are the results if you don't use "using PK" <<< In my case, it would not update the remote table. Once I added "USING my_primary_key" it worked like a charm. Javier Valencia 913-915-3137 _____ From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Monday, February 09, 2009 6:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Sconnect revisited Javier, Your scenario is basically what I do, I just project temp, update, drop temp, then repeat. My table do have a PK but it works fine without "using PK". What are the results if you don't use "using PK" Tom _____ From: Javier Valencia <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, February 9, 2009 5:20:07 PM Subject: [RBASE-L] - Re: Sconnect revisited Tom: I am working on similar application and this is how I do it SCONNECT. SATTACH remote table AS. Project Remote Table into temporary local table UPDATE local table with data from temporary table SDETACH ALL nochk SDISCONNECT. SCONNECT SATTACH remote table AS. Project Local Table into temporary local table UPDATE Remote table with data from temporary table SDETACH ALL nochk SDISCONNECT. It might be an overkill to disconnect and reconnect but it makes sure tables and buffers are updated. Also, don't forget that when you SATTACH a table you must use "USING your_primary_key" or "USING *" if you don't have a primary key; I was unable to update the remote database when I did not follow this rule. Javier Valencia 913-915-3137 _____ From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Sunday, February 08, 2009 8: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 HART <mailto:[email protected]> 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 HART <mailto:[email protected]> 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
