After reviewing help files a little more, it looks like the QualKey attribute
is automatically assigned, unless you specify a USING... parameter. I tried this and indeed was able to remove all QualKeys except the one I specified. However, I am not 100% sure what a QualKey actually does! Anyway, after SAttaching with the USING parameter that resulted in the table having only (1) QualKey column, the UPDATE command works as needed! No errors now! Another slight victory in the battle against my syntax ignorance. -Bob ----- Original Message ----- From: "ttc inc" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, June 10, 2010 2:30:50 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: ODBC table - QualKey column SSQL does not work in eep's with v7.5. This is an Rbase to Rbase database, same version, build etc. I would expect that I should be able to get this to work and that I simply do not have something Sattached correctly or something. I do a lot of work (almost 100% with foreign ODBC tables) and I would like to find out what the QualKey attribute is. If this was an update to some third party database, I would expect to have to work around. But I am hoping that it being Rbase to Rbase, I will be able to figure this out. So far, it looks as if a table is SAttached with a column alias name, you cannot update it with the native update command? --Bob ----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, June 10, 2010 1:44:09 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: ODBC table - QualKey column 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
