Dennis: MESSAGES and ERROR MESSAGES were set to ON.
Attempt Create Table, Insert Rows. Still no rows generated. Datatypes, everything I can think of, check out. Huh. Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, November 19, 2014 10:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Failure to PROJECT from VIEW 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
