Products
  
  
  Crash Magic Online
  
  Intersection Magic
  
  Map Magic
  
  Knowledge Base
  
  
  
  Contact Us
  
  Meeting
  
  Shop
  
  Login
  

 

Knowledge Base Article:IMW15 


Registration keys moved to client area: Select login on the left menu bar.

Knowldegebase:
Search home page  

Why do I have duplicate street names in the database?

Article created: Jun 09 1999, updated: Jun 09 1999

Background:  It would appear that there are two streets with the same name causing reports to list a street twice.

Status:  Intended behaviour - description
Keywords:  duplicates, street, changes
Categories:   *Installation and setup* *Data*

Explanation:
The streets file cannot have duplicates. It is more likely that one street is mis-spelled with one or more leading or trailing spaces (see also IMW0005).

Solution:
Navigate to 'reports\listings\streets in database', you will get a listing of streets (be sure to click on the FOR CHANGES radio button). You will need to find the two streets that look identical, and change the bad street to match exactly the good street (WITHOUT trailing or leading spaces). Answer OK to overwrite the file and then nav to 'utilities\database\change streets'. Answer affirmatively to all prompts and you should get a message to the effect that 1 street has been removed and one added.
July 19, 2018 10:53PM

© 1999-2018 Pd' Programming, Inc - Lafayette, CO USA