Bob In the old days when SSQL was not supported in EEP I used to have my SSQL commans in the starup dat file. When I closed the form where I needed SSQL command I set variable telling what SSQL was required closed all forms including mainmenu, then in my dat file I tested for the value executed my SSQL then returned to my mainmenu. This is cumbersome but can be done.
It is a lot easier to it directly in the EEP. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För [email protected] Skickat: den 10 juni 2010 23:54 Till: RBASE-L Mailing List Ämne: [RBASE-L] - RE: ODBC table - QualKey column Yes, I get the "illegal command in entry/exit procedure" message if I use SSQL in an EEP v. 7.5 In my v8 it works, but that is not an option for this particular app at this time. Hopefully in the future. -Bob ----- Original Message ----- From: "Gunnar Ekblad" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, June 10, 2010 3:48:25 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: ODBC table - QualKey column Are you sure? I cant recall when support for SSQL in eeps was implemented but I believe 7.5 would be fine 7.6 for sure is Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För [email protected] Skickat: den 10 juni 2010 21:31 Till: RBASE-L Mailing List Ämne: [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
