Total Mystery. Table created. Definition checks out in Designer. No message to screen after the insert. No TRACE error after the insert. REBOOT + RELOAD DB no effect. Been all over the typos. None. Table uniquely named.
Yes, may have to sleep on it. B -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, November 19, 2014 11:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Failure to PROJECT from VIEW So you can browse the output of the view but cannot insert the data into a table. what does it say on the screen after the insert? if it says rows were inserted, they should be in the table. Check if you have a typo. LIST Chart% to see if there is a similar table that is getting the data. Some other things to try. 1. Restart computer 2. Reload DB 3. Get a good night's sleep Dennis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Wednesday, November 19, 2014 1:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Failure to PROJECT from VIEW 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
