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
