Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 107
  • Last Modified:

updating command

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
TomBalla
Asked:
TomBalla
  • 2
1 Solution
 
vastoCommented:
What is "route" ? Record or column?
0
 
mlmccCommented:
Have you done a VERIFY DATABASE?

Also try LOGGING OFF the SERVER then LOGGING ON

mlmcc
0
 
TomBallaAuthor Commented:
logging on and off worked.  thanks.
0
 
mlmccCommented:
The log off and log on forces Crystal to read the table structure

mlmcc
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now