I'm experimenting in TEST, updating T_PHONE with a clean phone list from a vendor.
In SQL I created a table with phone and customer_no from the vendor list.
I ran a query to join the tables on the customer_no and set T_PHONE.phone to the newphone.phone on t_phone.customer_no = newphone.customer_no
There are a total of 4900 records to update, which it seems to do just fine...
EXCEPT...
if I look in Tess TEST, it only seems to update the first 4100 records. When I pull one of the last several hundred constituent IDs, the phone is blank. If I query T_PHONE for that very same constituent ID it shows the correct phone number has been populated.
Any ideas?
Oh, not that it matters but where type =1 so I didn't replace all of their phone numbers with the same number.
This may be part of it. The constituents that don't show a number in TESS even though it's in T_PHONE, did not have any phone number before.
Did you populate the address_no for the new phone1s for the people who previously had no phone at all?
Ah-ha, and no I didn't .
It appears those constituents don't have an entry in T_PHONE at all.