Solved

updating command

Posted on 2014-11-06
4
100 Views
Last Modified: 2014-11-06
I have a command I made, that combines two databases.  a history and a current.  We added two new routes, but my report doesn't show the two new routes.  Do I have to refresh the command or do I need to fix my command?

Here is the current code.

select
dbo.InvMaster.ConvFactOthUom,
dbo.InvMaster.StockCode,
dbo.SorDetail.SalesOrder,
dbo.SorDetail.MStockCode,
dbo.SorDetail.MStockDes,
dbo.SorDetail.MWarehouse,
dbo.SorDetail.MOrderQty,
dbo.SorDetail.MOrderUom,
dbo.SorDetail.MPrice,
dbo.SorDetail.MDiscValue,
dbo.SorDetail.MStockUnitMass,
dbo.SorDetail.MConvFactAlloc,
dbo.SorMaster.SalesOrder,
dbo.SorMaster.OrderStatus,
dbo.SorMaster.OrderDate

FROM dbo.InvMaster INNER JOIN
dbo.SorDetail ON dbo.InvMaster.StockCode = dbo.SorDetail.MStockCode INNER JOIN
dbo.SorMaster ON dbo.SorDetail.SalesOrder = dbo.SorMaster.SalesOrder

union


select
SysproCompanyY.dbo.InvMaster.ConvFactOthUom,
SysproCompanyY.dbo.InvMaster.StockCode,
SysproCompanyY.dbo.SorDetail.SalesOrder,
SysproCompanyY.dbo.SorDetail.MStockCode,
SysproCompanyY.dbo.SorDetail.MStockDes,
SysproCompanyY.dbo.SorDetail.MWarehouse,
SysproCompanyY.dbo.SorDetail.MOrderQty,
SysproCompanyY.dbo.SorDetail.MOrderUom,
SysproCompanyY.dbo.SorDetail.MPrice,
SysproCompanyY.dbo.SorDetail.MDiscValue,
SysproCompanyY.dbo.SorDetail.MStockUnitMass,
SysproCompanyY.dbo.SorDetail.MConvFactAlloc,
SysproCompanyY.dbo.SorMaster.SalesOrder,
SysproCompanyY.dbo.SorMaster.OrderStatus,
SysproCompanyY.dbo.SorMaster.OrderDate


FROM SysproCompanyY.dbo.InvMaster INNER JOIN
SysproCompanyY.dbo.SorDetail ON SysproCompanyY.dbo.InvMaster.StockCode = SysproCompanyY.dbo.SorDetail.MStockCode INNER JOIN
SysproCompanyY.dbo.SorMaster ON SysproCompanyY.dbo.SorDetail.SalesOrder = SysproCompanyY.dbo.SorMaster.SalesOrder
0
Comment
Question by:TomBalla
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 18

Expert Comment

by:vasto
ID: 40426440
What is "route" ? Record or column?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40426517
Have you done a VERIFY DATABASE?

Also try LOGGING OFF the SERVER then LOGGING ON

mlmcc
0
 

Author Comment

by:TomBalla
ID: 40426559
logging on and off worked.  thanks.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40426683
The log off and log on forces Crystal to read the table structure

mlmcc
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Reports with Yardi error 800a004b 2 162
Exporting Crystal report withh dynamic image in C# 5 97
Crystal Reports 13 5 95
division by zero in crystal reports 1 35
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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