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 <[email protected]><mailto:[email protected]> 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 --- 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]<mailto:[email protected]>. For more options, visit 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 [email protected]<mailto:[email protected]>. For more options, visit 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 [email protected]<mailto:[email protected]>. For more options, visit 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
