It's a "Qualifying" key. Whatever most closely approximates a unique index
key, if any.
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 10, 2010 3:48 PM
Subject: [RBASE-L] - RE: ODBC table - QualKey column
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
