I have this code (part of it) and i get this "From Keyword not found where expected". i tried to put spaces btw From but no result. any help?
strSQL = " select walitm as 2nd Item Number, Case when wlqmto>0 then wlqmto Else wlsoqs End as RackWind Start,"
strSQL = strSQL & " walotn as Lot / Serial, wadcto as Type,"
strSQL = strSQL & " wadl01 as Item Description, to_date(watrdj + 1900000,'YYYYDDD') as Order Date, wadoco as Order No, wasrst as Status,"
strSQL = strSQL & " wawr01 as Line, wawr02 as Cell, wauom as UOM, wamcu as Branch / Plant, to_date(wadrqj + 1900000,'YYYYDDD') as Request Date, to_date(wastrt + 1900000,'YYYYDDD') Start Date"
strSQL = strSQL & " From proddta.f4801, proddta.f4102, proddta.f3112 WHERE walitm = Iblitm"
strSQL = strSQL & " And WLDOCO = WADOCO"
strSQL = strSQL & " And wlopsq = '1000'"
strSQL = strSQL & " And wadcto <'WZ'"
strSQL = strSQL & " And wasrst <> '98'"
strSQL = strSQL & " And wasrst <> 'E1'"
strSQL = strSQL & " And wamcu = ' USE03M'"
strSQL = strSQL & " And Ibmcu = ' USE03M'"
strSQL = strSQL & " And wawr01 in ('001','006','016')"
strSQL = strSQL & " And to_date(watrdj + 1900000,'YYYYDDD') > sysdate - 7"