If a column name is computed, such as Total CURRENCY = (SalePrice*NumSold) you cannot put it in as plain CURRENCY. You have to carry the calculation with it.
Albert > On Apr 17, 2018, at 2:54 AM, Alastair Burr <adbb...@outlook.com> wrote: > > Interesting, I, too, had a problem with this a while ago. > > I had/have a view that causes me a problem with column type(s) that does not > seem to be solved with a pre-defined table to "fix" the column type. > > However, I have not been able to prove that the problem is with the view. For > me, it is a relatively complicated view but I wouldn't think it complicated > for R:Base. It's resolved by simply turning ColCheck on or off as required. > > I chose not to waste more time looking for the answer when I had a > work-around. Nevertheless, I would be grateful if you find a solution if you > would post it here. > > Regards, > Alastair. > > > > On 16/04/2018 18:37, 'rehan wyne' via RBASE-L wrote: >> Yes. >> I also tried by setting COLCHECK OFF. Such that Project command may work and >> do not raise error i.e. "As Column XYZ is used in another table, its type >> cannot be redefined." >> >> Rehan Wyne >> >> On Monday, April 16, 2018, 6:44:53 PM GMT+5, Alastair Burr >> <adbb...@outlook.com> <mailto:adbb...@outlook.com> wrote: >> >> >> Do you have COLCHECK set to ON to specify checking? >> >> Regards, >> Alastair. >> >> On 16/04/2018 13:08, 'rehan wyne' via RBASE-L wrote: >>> Hello All, >>> >>> I have defined all controlled column names and their data types in >>> "controlled_column_names table", that will be enforced in creating a view >>> when using similar columns names. >>> >>> After a view is created, I noticed it did not picked up the column data >>> type as defined in controlled_column_names. >>> >>> A view's column definition could be build from sum(XYZ) or union of columns >>> from different tables. >>> >>> I am facing a type mismatch error when I use "Project Temporary" command. >>> >>> I am using R:Base X Enterprise 10.0.3. >>> >>> >>> Any Clue ? >>> >>> >>> Rehan Hamid Wyne >>> >>> -- >>> For group guidelines, visit >>> http://www.rbase.com/support/usersgroup_guidelines.php >>> <http://www.rbase.com/support/usersgroup_guidelines.php> >>> --- >>> 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 rbase-l+unsubscr...@googlegroups.com >>> <mailto:rbase-l+unsubscr...@googlegroups.com>. >>> For more options, visit https://groups.google.com/d/optout >>> <https://groups.google.com/d/optout>. >> >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <http://www.rbase.com/support/usersgroup_guidelines.php> >> --- >> 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 rbase-l+unsubscr...@googlegroups.com >> <mailto:rbase-l+unsubscr...@googlegroups.com>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <http://www.rbase.com/support/usersgroup_guidelines.php> >> --- >> 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 rbase-l+unsubscr...@googlegroups.com >> <mailto:rbase-l+unsubscr...@googlegroups.com>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > 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 rbase-l+unsubscr...@googlegroups.com > <mailto:rbase-l+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.