Updating a View in MS SQL 2000 for Navision 3.7
Posted on 2010-09-10
I am trying to create a keyed import in UPS WorldShip to gather data from Navision 3.7. The database is MS SQL 2000 and there is a view in SQL that has all of the information I am trying to get into WorldShip, but it only seems to gather data once a day. If I scan an order right now I only get shipping data from orders that were placed yesterday. If I look in the view it only shows the orders from yesterday. We had to use the view because WorldShip keyed import would not allow symbols and spaces in the table name and SQL has both in all of our table names. Does anyone know how I could get this view to update hourly, or get the keyed import in UPS WorldShip to work directly with our table regardless of naming convention?