At 06:05 PM 4/2/2014, Mike Byerley wrote:
This shorter version works too...
CREATE VIEW MyFormView AS SELECT +
PrimKeyColumn, DataColumn LastUpdated as LastUpdatedT1 FROM MyTable
At 02:30 PM 4/2/2014, Bill Downall wrote:
That feature of R:BASE goes back a long way -- to a time before R:BASE
had implemented SQL Primary Keys and Foreign Keys. For R:BASE, if you
name a column the same in two tables, an R:BASE Form will assume that
the same-named columns are linking columns, and look for matching values.
just like PKs and FKs.
There is a way around it, through update-able views. Create a view on
one of the tables that renames the column that has the same name but
is not a linking column. Be sure the view has no features that would
make it a non-updateable view (no GROUP BY, no ORDER BY, no Aggregate
functions (SUM, MIN, MAX, COUNT, AVG). Then use that view in the form
instead of its underlying table.
CREATE VIEW MyFormView +
( PrimKeyColumn, DataColumn, LastUpdatedT1 ) +
AS SELECT +
PrimKeyColumn, DataColumn LastUpdated +
FROM MyTable
While upgrading and converting any LEGACY databases and applications,
the database normalization is a work of art and patience!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
