Claudine: Appreciate your help. This opens each of the involved files:
DEBUG SET TRACE ON SET ERROR MESSAGE 2038 OFF SET ERROR MESSAGE 667 OFF DROP TABLE <TempTable_1> ... DROP TABLE <TempTable_n> DROP VIEW <View_1> ... DROP VIEW <View_n> SET ERROR MESSAGE 667 ON SET ERROR MESSAGE 2038 ON ... Ultimately: Fails: CREATE VIEW <SourceView> ... PROJECT <TargetTable> ... Succeeds: CREATE VIEW <SourceView> ... PROJECT TEMP <TargetTable> ... Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Friday, November 21, 2014 2:26 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Failure to PROJECT from VIEW: Education Needed Bruce, Somehow your projected table already exists... SET ERROR MESSAGE ON SET MESSAGE ON SET ERROR MESSAGE 2038 OFF DROP TABLE `ProjectedTable` NOCHECK SET ERROR MESSAGE 2038 ON PROJECT `ProjectedTable` FROM TABLE USING ALL WHERE Maybe you'll get an error that gives you a clue. Claudine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Friday, November 21, 2014 3:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Failure to PROJECT from VIEW: Education Needed So I created a test database with a simple table set, generated a view, then successfully PROJECTED the view rows into the projected table. Rhetorical question: Why has this behavior failed - after successful operation - in established databases? What conditions would prevent the projection of data rows? Why would it work now? Any perspective appreciated. Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Friday, November 21, 2014 10:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Failure to PROJECT from VIEW: New Perspective Thank you. Good call. STATICDB is set OFF in my startup configurations, and is OFF when having my issue. Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Thursday, November 20, 2014 12:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Failure to PROJECT from VIEW: New Perspective Bruce, First thing that comes to mind is STATICDB is ON. Claudine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Thursday, November 20, 2014 1:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Failure to PROJECT from VIEW: New Perspective All: I'm in a different database, running an RMD projecting from a view into a table "on the fly". Same failure, this time in a routine that was working without fail up through May 2014. The process works, if I change PROJECT <tablename> to PROJECT TEMP <tablename> Can anyone explain what is going on here? Much appreciated. Bruce Chitiea SafeSectors, Inc. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Wednesday, November 19, 2014 9:28 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Failure to PROJECT from VIEW All: This has to be basic. An RMD file successfully: - DROPs a previously PROJECTed table - DROPs a previously created VIEW - CREATEs a viable view - PROJECTs the view structure ... ... but fails to project any data rows. TRACE reports no errors in: <Snip> CREATE VIEW Chart_A500_Humpty_vw + ( FYear, Slab, InWall, Sewer, Member, Unknown ) AS + SELECT FYear, c74110, c74120, c74130, c74150, c74160 + FROM Chart_A500_Joinup_vw BROWSE * FROM Chart_A500_Humpty_vw + OPTION WINDOW_STATE MAXIMIZED PROJECT Chart_A500_ProjectTable + FROM Chart_A500_Humpty_vw + USING * + ORDER BY FYear BROWSE ALL FROM Chart_A500_ProjectTable <Snip> BROWSE for the projected table returns "No rows in table, INSERT a NULL row?". [Bruce Chitiea] Alternately, the columns are specified in the PROJECT command: USING FYear, Slab, InWall, Sewer, Member, Unknown ... without result. Thoughts? Bruce Chitiea SafeSectors, Inc. eCondoMetrics --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
