syntax errror

[#1]

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

[maneshkhottcpl]

Hi,

Please explain ur issue in details. What time u r getting this error?

[#3]

Thanks for your help, but i think i figured out the issue.

Thanks

Adam

[pgalvezt]

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.

[suniljain]

if there is space between totalcost then place brackert

[pgalvezt]

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.