lcsql = "SELECT * INTO #runsrpt " + ; "FROM RUN FULL OUTER JOIN RUNUSER ON RUN.RUN_AUTOID = RUNUSER.RUNUSER_RUN_AUTOID " + ; "WHERE Run.Run_AutoID = " + ALLTRIM(STR(gnID)) lnRet = gocnn.execute(lcsql, @lncount)One table is created, then populated with the following command:
lcsql = 'INSERT INTO #RUNSCHOOL VALUES(' + lctmpstring + ')' lnRet = gocnn.execute(lcsql, @lncount)lncount in both instances comes back greater then 0.