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
--- 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.
================================================
