Instead of using project, create the target table and then use INSERT to populate it.
Also, check MESSAGES and ERROR MESSAGES settings. They should be ON. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Wednesday, November 19, 2014 11: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?". 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 =======================3D=======================3 D= 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) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= 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. =======================3D=======================3 D=
