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
