Lena,
I would not suppress that exact error message nor
any -ERROR- messages when converting and/or
upgrading a database from a LEGACY DOS/WIN
version to R:BASE X or R:BASE X Enterprise (Version 10).
A few suggestions ...
01. Find all instances of "OnHand" column in your database
LIST COLUMN OnHand
This will provide you with a list of all
tables with "OnHand" including any DEFAULT values or Expressions.
02. Now compare the definition of OnHand column
with the same column name when defining VIEW.
In your case, for example, the column OnHand in
InventoryLocations table might have an expression like this:
OnHand REAL = (BegInvCount+InventoryAdded-InventoryUsed)
If that is not the same expression defined for
"OnHand" column when defining a VIEW, you will
get that -ERROR- message, which will result in
not creating that particular view.
If in fact that is the case, you cannot define
the same column OnHand in VIEW as (SUM(OnHand)),
etc. Basically, that would be considered as
"incompatible" when the same column is used in
the original table with a different expression as
explained above. In this specific case, you may
consider using a different column (alias) name when defining view.
FYI, column definitions along with column
integrity rules may not be suppressed in R:BASE X
and R:BASE X Enterprise (Version 10 and Version 10.5).
Hope that explains and provides you with some blue's clues ...
Very Best R:egards,
Razzak
At 05:31 PM 8/17/2017, Lena Dammstrom wrote:
Preparing to convert from 9.5 to RBaseX ver 10.0.2.20731
Doing some testing to make sure we don’t run into conversion issues.
Running some old code that creates views
COLCHECK is OFF
When running the code in RB9.5, it creates the
views, and does not display any errors messages/warnings
When running the same code in RBase X I get error messages/warnings like:
<WARNING> The data type for column OnHand is not
compatible with other uses of that column name (1577)
So I figured I would just SET ERROR MESSAGE 1577 OFF
Yet I still keep getting these warnings.
I confirmed that 1577 was off (before running a
create view, and after view was created)
R>set var vlcd2 text = (GETVAL('CheckMessageStatus','1577'))
Value of vlcd2 is OFF
I even SET ERROR MESSAGES OFF – but still get the warnings.
Any clues as to what setting I am missing to suppress the warning message?
Thank you in advance for your time.
Regards
Lena
<http://www.qmiusa.com/>
[]
Lena Dammstrom
Software Developer
Email: <mailto:[email protected]>[email protected]
Toll Free: 800-446-2500
International: 01 630-529-7111
Extension: 1037
<http://www.qmiusa.com>www.qmiusa.com
.
----------
This email may contain material that is
confidential, privileged and/or attorney work
product for the sole use of the intended
recipient. Any review, reliance or distribution
by others or forwarding without express
permission is strictly prohibited. If you are
not the intended recipient, please contact the sender and delete all copies
--
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
<mailto:[email protected]>[email protected].
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
