Thank you Alastair and Albert for your suggestions and interest in solving this
issue. I am also in touch with the R:Base Support desk also.
My main Idea is, for making a complex view made up of multiple union(s) from
different tables and views containing multiple numeric and text columns. We
should be able to specify each column's datatype in "Create view definition" or
it should be resolved with a pre-defined table to "fix" the columns data types.
Below is the sample code from Oracle, to elaborate how desired columns data
type are achieved through Type Casting.
CREATE VIEW myview
AS
SELECT x, SUM(y) y_normal, CAST( SUM(y) AS NUMBER(7)) y_cast
FROM t
Name Null? Type
------------------------------------ -------- -------------------------
X VARCHAR2(5)
Y_NORMAL NUMBER
Y_CAST NUMBER(7)
CREATE VIEW ABC
ASSELECT CAST ('19' AS number) AS XYZFROM DUAL
Rehan Hamid Wyne
On Tuesday, April 17, 2018, 7:57:02 PM GMT+5, Albert Berry
<[email protected]> wrote:
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 <[email protected]> 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 youwould 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]> 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
[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
[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
[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.
--
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.
--
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.
