I wouldn't have taken the view description as a calculation. The Ifgt is just mapping which col to assign to FontColor.
So it's still a single table view. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, October 28, 2008 6:08 PM Subject: [RBASE-L] - Re: Single table view NOT editable in form? > Hmm... I'm really surprised that this is editable at all with that > calculation in there. I was under the impression it wouldn't be. > > Can't help you. Don't think I've ever used a view in a form. > > Karen > > > >> << >> Single-table views are not editable if they contains any aggregate columns. >> Not sure what you mean by "adds two calculated columns", but if this is a >> calculation within the view, then the entire view is not editable. Nor are >> sorted views. >> >> >> >> No, this is an editable view -- no aggregates, no GROUP BY. It's editable >> in the BROWSEr, so I know it's working as expected. Just not in forms. >> >> >> The view definition is along the lines of: >> >> >> CREATE VIEW TableDisp (Col1, Col2, FontColor) AS SELECT Col1, Col2, >> (IFGT(Col1, Col2, 'RED', 'BLACK')) >> >> >> and Col1 and Col2, while editable in a BROWSE window are not editable in a >> form. >> -- >> Larry >> >> >> >
