... into Cursor csrNewRESUs NOFILTER * Comment ; lnRecCount = _TALLY If lnRecCount > 0 ...>Curious problem I've never come across before. Consider the code below (an example as a very similar error occured in a similar piece):
>Select *, RTE_NO + GEN + DIRECTN + STR( ESU_ID, 11) ; > from mclMPSer!ROUTE_ESU ; > where RTE_NO + GEN + DIRECTN + STR( ESU_ID, 11) not in ; > ( Select Rte_No + Gen + Directn + STR( ESU_ID, 11) ; > from RouteESUMap) ; > into Cursor csrNewRESUs NOFILTER > >lnRecCount = _TALLY >If lnRecCount > 0 && then new ROUTE_ESUs to copy over > Wait WINDOW "Updating GIS RouteESUMap table with new Route-ESUs from mPlan ..." NOWAIT NOCLEAR > Select csrNewRESUs > ... >>