TomBalla
asked on
Error creating command
Getting an ADO error when trying to create a command. "Conversion failed when converting date and/or time from character string.
I don't normally use commands so I could be doing something wrong.
select
dbo.InvMaster.ConvFactOthU om,
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.MStockUnitMa ss,
dbo.SorDetail.MConvFactAll oc,
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
CompanyY.dbo.InvMaster.Con vFactOthUo m,
CompanyY.dbo.InvMaster.Sto ckCode,
CompanyY.dbo.SorDetail.Sal esOrder,
CompanyY.dbo.SorDetail.MSt ockCode,
CompanyY.dbo.SorDetail.MSt ockDes,
CompanyY.dbo.SorDetail.MWa rehouse,
CompanyY.dbo.SorDetail.MOr derQty,
CompanyY.dbo.SorDetail.MOr derUom,
CompanyY.dbo.SorDetail.MPr ice,
CompanyY.dbo.SorDetail.MDi scValue,
CompanyY.dbo.SorDetail.MSt ockUnitMas s,
CompanyY.dbo.SorDetail.MCo nvFactAllo c,
CompanyY.dbo.SorMaster.Sal esOrder,
CompanyY.dbo.SorMaster.Ord erDate,
CompanyY.dbo.SorMaster.Ord erStatus
FROM CompanyY.dbo.InvMaster INNER JOIN
CompanyY.dbo.SorDetail ON CompanyY.dbo.InvMaster.Sto ckCode = CompanyY.dbo.SorDetail.MSt ockCode INNER JOIN
CompanyY.dbo.SorMaster ON CompanyY.dbo.SorDetail.Sal esOrder = CompanyY.dbo.SorMaster.Sal esOrder
I don't normally use commands so I could be doing something wrong.
select
dbo.InvMaster.ConvFactOthU
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.MStockUnitMa
dbo.SorDetail.MConvFactAll
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
CompanyY.dbo.InvMaster.Con
CompanyY.dbo.InvMaster.Sto
CompanyY.dbo.SorDetail.Sal
CompanyY.dbo.SorDetail.MSt
CompanyY.dbo.SorDetail.MSt
CompanyY.dbo.SorDetail.MWa
CompanyY.dbo.SorDetail.MOr
CompanyY.dbo.SorDetail.MOr
CompanyY.dbo.SorDetail.MPr
CompanyY.dbo.SorDetail.MDi
CompanyY.dbo.SorDetail.MSt
CompanyY.dbo.SorDetail.MCo
CompanyY.dbo.SorMaster.Sal
CompanyY.dbo.SorMaster.Ord
CompanyY.dbo.SorMaster.Ord
FROM CompanyY.dbo.InvMaster INNER JOIN
CompanyY.dbo.SorDetail ON CompanyY.dbo.InvMaster.Sto
CompanyY.dbo.SorMaster ON CompanyY.dbo.SorDetail.Sal
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER