So in my example Sattach MainTable as ArchTable I can just update ArchTable from MainTable and thats it
Tom Hart ----- Original Message ---- From: Emmitt Dove <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, November 3, 2008 9:47:32 AM Subject: [RBASE-L] - Re: Razzaks Reply: ODBC Error Unrecognized columninexpression(2160) Tom, SATTACHed tables work just like any normal table. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] From:[email protected] [mailto:[EMAIL PROTECTED] On Behalf Of TOM HART Sent: Monday, November 03, 2008 10:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Razzaks Reply: ODBC Error Unrecognized columninexpression(2160) Since we are on this subject, I was following the recent posts, and had a slap your head,where has this been all my life! I have been unloading the data to update 2 databases, but with the Sconnect/Sattach it is much easier and I have had no problem doing it, but do have a question: I do the following Connect MainDatabase Sconnect ArchDatabase Sattach MainTable as ArchTable project temp TempTable from ArchTable using all then I do my updates on MainTable from TempTable this all works absolutely fabulous-wow I should have had a V-8 my question is how do I update the MainTable in the ArchDatabase ?project temp TempTable1 from MainTable using all then update ArchTable???? Tom Hart Original Message ---- From: A. Razzak Memon <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, November 3, 2008 9:12:30 AM Subject: [RBASE-L] - Re: Razzaks Reply: ODBC Error Unrecognized columninexpression(2160) Good morning Chuck, Thanks for reminding me regarding the ODBC Error Unrecognized column in expression (2160). Wow!!! In your subject line, are you asking for help or demanding a reply from this list of volunteers? Sometimes It is hard to interpret an e-mail. I didn't realize that it was an emergency. Otherwise I would have taken a private plane to Madison Heights, MI to help you in person. Unfortunately, either my crystal ball is not working or I can not see all details and play with your tables remotely. The best advise I can give you is to either send a sample with all details and steps to replicate to [EMAIL PROTECTED] or better yet, try to replicate the scenario using any sample database such as RRBYW14. I am assuming that both involved databases in your scenario are Turbo V-8 databases and you have followed the suggested steps to upgrade all Turbo V-8 database using the latest available updates of R:BASE Turbo V-8 for Windows. R:BASE Turbo V-8 for Windows (Build: 8.0.18.30919): http://www.rupdates.com/rbg8/ http://www.rupdates.com/rbg8/enterprise/ http://www.rupdates.com/rbg8/corporate/ http://www.rupdates.com/rbg8/rcompiler/ http://www.rupdates.com/rbg8/runtime/ Hope that helps! Very Best R:egards, Razzak. At 09:33 AM 11/3/2008, [EMAIL PROTECTED] wrote: >Is there anything else need to point me in the correct direction ? > >Listing from sattached table. > >Table: CLLI No Lock(s) > Descr: Server table - CLLI Amer 8.0 >No. Column Name Attributes >--- ------------------ >------------------------------------------------------ > 1 STATE Type : TEXT 2 QualKey > 2 NPA Type : INTEGER QualKey > 3 NXX Type : INTEGER QualKey > 4 LINE_RG Type : TEXT 17 QualKey > 5 POOLED Type : TEXT 9 QualKey > 6 PORTED_IN Type : TEXT 17 QualKey > 7 LINE_RG_EX Type : TEXT 25 QualKey > 8 EFF_DATE Type : DATE QualKey > 9 STATUS1 Type : TEXT 12 QualKey > 10 USAGE Type : TEXT 9 QualKey > 11 RATE_DIST Type : TEXT 25 QualKey > 12 RATE_CENT Type : TEXT 21 QualKey > 13 SAG_NPA Type : DOUBLE QualKey >No. Column Name Attributes >--- ------------------ >------------------------------------------------------ > 14 SAG_EXC Type : TEXT 16 QualKey > 15 SAG_CO Type : TEXT 9 QualKey > 16 CLLI Type : TEXT 16 QualKey > 17 ENG_NAME Type : TEXT 35 QualKey > 18 EXC_KEY Type : DOUBLE QualKey > 19 HOST_CLLI Type : TEXT 15 QualKey > 20 TAND_CLLI Type : TEXT 14 QualKey > 21 CLLI_STATU Type : TEXT 13 QualKey > 22 NET_FUNCT Type : TEXT 29 QualKey > 23 SWITCH_TYP Type : TEXT 15 QualKey > 24 BU_SWITCH_ Type : TEXT 17 QualKey > 25 LATA_NAME Type : TEXT 26 QualKey > 26 LATA_NUMBE Type : DOUBLE QualKey > Current number of rows: SERVER > >Listing from same table in local DB (Source) > > > Table: CLLI No Lock(s) > Descr: SBC CLLI Information >No. Column Name Attributes >--- ------------------ >------------------------------------------------------ > 1 STATE Type : TEXT 2 > 2 NPA Type : INTEGER > 3 NXX Type : INTEGER > 4 LINE_RG Type : TEXT 17 > 5 POOLED Type : TEXT 9 > 6 PORTED_IN Type : TEXT 17 > 7 LINE_RG_EX Type : TEXT 25 > 8 EFF_DATE Type : DATE > 9 STATUS1 Type : TEXT 12 > 10 USAGE Type : TEXT 9 > 11 RATE_DIST Type : TEXT 25 > 12 RATE_CENT Type : TEXT 21 > 13 SAG_NPA Type : DOUBLE >No. Column Name Attributes >--- ------------------ >------------------------------------------------------ > 14 SAG_EXC Type : TEXT 16 > 15 SAG_CO Type : TEXT 9 > 16 CLLI Type : TEXT 16 > 17 ENG_NAME Type : TEXT 35 > 18 EXC_KEY Type : DOUBLE > 19 HOST_CLLI Type : TEXT 15 > 20 TAND_CLLI Type : TEXT 14 > 21 CLLI_STATU Type : TEXT 13 > 22 NET_FUNCT Type : TEXT 29 > 23 SWITCH_TYP Type : TEXT 15 > 24 BU_SWITCH_ Type : TEXT 17 > 25 LATA_NAME Type : TEXT 26 > 26 LATA_NUMBE Type : DOUBLE > Current number of rows: 65535 > > >SCONNECT ";driver=R:BASE 8.0 Database Driver >(*.rx1);dbq=L:\Amer;uid=xxxxx;pwd=xxxxxx" >sattach clli as cll
