I use SSQL to update foreign databases.
It is much faster, even if you could get the update on the sconnected table to
work.
SCONNECT odbcname
SSQL sqlcommand
Retrieving data from the sconnected table works fine.
Dennis McGrath
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Thursday, June 10, 2010 1:27 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - ODBC table - QualKey column
I am having a issue with an RBASE ODBC table. (Rbase database to Rbase
database, both 7.5)
When I try to update a row, I get the message :
[RBTI][R:BASE 7.5 ODBC ODBC Driver][]-ERROR-Column ItemNumber not found (2369)
I can browse this table and select from it, but if I try to update a column
value, I get the
above error.
I do not know, but I wonder if something is linked with a column being
designated
as a "QualKey" column. Below is the listing for the ODBC linked table.
Table: Multipart No Lock(s)
Descr: Server table - MultiPart ;driver=R:BASE 7.5 Database Driver
Descr: (*.rb1);dbq=g:\rbti\rbg7\HOF
No. Column Name Attributes
--- ------------------ ------------------------------------------------------
1 RackNo Type : TEXT 8 QualKey
2 SkidLength Type : INTEGER QualKey
3 SkidQty Type : INTEGER QualKey
4 ItemNumber Type : TEXT 12 QualKey
Comment: #ItemNo
5 CurrentItem Type : TEXT 12 QualKey
6 CurrentQty Type : INTEGER QualKey
7 PrevItem Type : TEXT 12 QualKey
8 PrevQty Type : INTEGER QualKey
9 CurrentDate Type : DATE QualKey
10 TransActionNumber Type : INTEGER QualKey
11 Inventory_Type Type : TEXT 8
12 LocNotes Type : NOTE 4012
No. Column Name Attributes
--- ------------------ ------------------------------------------------------
13 Serial# Type : INTEGER
Current number of rows: SERVER
Notice that many columns show up as "QualKey". I have often wondered what
this is. Not
all the columns list this and I see no common thread. The foreign table only
has one index
on it. (RackNo).
So two questions:
1: Any clues as to why I cannot update a row in this table via the ODBC
connection. (I have checked
the table and there are no locks, etc.) The error states something is wrong
with the column ItemNumber.
This is an alias for the actual column name ItemNo. I cannot use that name on
the SAttached table as the
column is defined differently in the open database)
2: What is the QualKey designation mean? Is it an attribute that one can
control? (remove etc.)
Thanks,
-Bob
