Solved

Updating a View in MS SQL 2000 for Navision 3.7

Posted on 2010-09-10
2
374 Views
Last Modified: 2012-05-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?
0
Comment
Question by:jusery7
2 Comments
 
LVL 7

Expert Comment

by:rmm2001
ID: 33654902
My guess is that your view has a constraint just to show the previous day's orders and that's why it's filtering to that. To scan whenever you wanted to you could get the sql from the view and then change the WHERE clause to be something between say now and yesterday. You probably don't want to completely take it off as that would probably return more orders than what you are looking for.
0
 
LVL 1

Accepted Solution

by:
jusery7 earned 0 total points
ID: 33790746
Actually it turned out that I had another table that is no longer in use that was not updating anymore.  I removed the old table and it updates in real time.  Thanks for the suggestions.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now