× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



   Sheri,

   Just as an fyi, what is probably happening is your trying to update a
   customer for co 2 that doesn't have a corresponding customer in co 1( i.e.
   returns NULL value ).

   This should take care of that situation:

   update cust cus
   ----  update cust_store value with value from corresponding co 1 customer.
      set cus.cust_store = ( select substr( cust_store, 2, 6 )
                              from  cust
                             where  cust_co_no  =  1
                              and   cust_no     =  cus.cust_no )
   ---- only update customers for co 2 that have a corresponding co 1
   customer( i.e. so no nulls are returned ).
   where  cus.cust_co_no  =  2
    and   cus.cust_no in( select cust_no
                           from  cust
                          where  cust_co_no  =  1 )
   hth,
   Billy

 Unfortunately, this did not work (tried it both ways).  I received an
 error message:  Null values not allowed in column or variable CMSTOR. 

 *************************************************
 This should work:
 Update Customer a
        set Customer_Store = (select 'C'||Customer_Store from Customer
 where
 Cust#=a.Cust# and Company=1)
        where Company=

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.