Thank you Razzak. I had a feeling it had something to do with the Sum(OnHand). The table OnHand is defined as Real and it looks like view Sum(OnHand) comes out as double.
Again many thanks for your insight into my situation. Regards Lena Lena Dammstrom Software Developer Email:ldammst...@qmiusa.com Toll Free: 800-446-2500 International: 01 630-529-7111 Extension: 1037 www.qmiusa.com ------------------------------------------ The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information. -----Original Message----- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Thursday, August 17, 2017 8:15 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Suppressing Error 1577 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:ldammst...@qmiusa.com>ldammst...@qmiusa.com >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:rbase-l+unsubscr...@googlegroups.com>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. -- 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.
