Well I found the offending view. Problem is, this database has a large number of tables and views so the DB structure check is taking a long time, even on a local copy.
Is there any way around this delay? Thanks Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, January 20, 2010 3:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway question Ahha! Thank you Emmitt. I think you are right on target! I don't think it has anything to do with the REPLACE because all that says is empty the table before importing. I will search SYS_Views to see if I can find the offender. Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Wednesday, January 20, 2010 3:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway question Dennis, That sounds like a view definition error. While it may not seem to be pertinent to a GATEWAY command, it could be that R:BASE is re-evaluating structures when you do the REPLACE, just as it will check through all the forms and reports when you do an ALTER TABLE without NOCHECK. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, January 20, 2010 15:57 To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway question Using 7.6 I have two databases. Both have an identical table - ImportData I issue this command: GATEWAY IMPORT CSV c:\hurricane\Fasten\1.csv REPLACE ImportData The command executes instantly in database#1 The data is perfect The command hangs in database#2 I get the error: Column UniqueID not found in T1 Any ideas? Thanks DennisMcGrath
