Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why am I getting this error?
Field not found - <TotalCost>
ITEMLOC:
Load
VersionNum,
ItemNumLoc,
LocationNum,
DescriptionLoc,
PiecesOnHand,
TotalCost as TotalCostLoc
From q:\abauman\qlikview_qvd\youarehereab.qvd
(qvd)
and then also this error:
ODBC connection failed
ITEMLOC:
SQL SELECT *
FROM TTM.ITEMLOC
Hi,
Please explain ur issue in details. What time u r getting this error?
Thanks for your help, but i think i figured out the issue.
Thanks
Adam
ITEMLOC:
Load
VersionNum,
ItemNumLoc,
LocationNum,
DescriptionLoc,
PiecesOnHand,
TotalCost as TotalCostLoc
From q:\abauman\qlikview_qvd\youarehereab.qvd
(qvd);
You missed the semicolon, I think. You must close each sentece or line that you've charged or created.
Make sure that the Database is in the right folder. Maybe the database was moved to another direction.
if there is space between totalcost then place brackert
ITEMLOC:
Load
VersionNum,
ItemNumLoc,
LocationNum,
DescriptionLoc,
PiecesOnHand,
TotalCost as TotalCostLoc
From q:\abauman\qlikview_qvd\youarehereab.qvd
(qvd);
You missed the semicolon, I think. You must close each sentece or line that you've charged or created.
Make sure that the Database is in the right folder. Maybe the database was moved to another direction.