At 12:46 PM 7/25/2016, Stuart Hellman wrote:
I've created a view which is a union of other views that contains a
portion of my original table.
I can display the view, but when I click on a node in the DB Tree
View, it's as if nothing is
selected. The values of my variables which contain the IDs of the
parent and child nodes are not
changed.
In testing I've tried including all the views in the union, the
original table in which the views
were created, using the view as the main table and as a slave table.
What am I missing???
Obviously, you have created a view using the Query Wizard. In that
case, the view column names are
defined as T1.columnname, T2.columnname, etc.
It appears to not work because the fields between datasets don't
match. Master table has "Field"
the view has "T1.Field". The view should drop the "T1" in the field
name so fields are matched.
You will have to re-design the view with unique and/or alias column names.
Hope that provides you with some blue's clues ...
Very Best R:egards,
Razzak
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
