I am having a problem with using a temp file on SQL as a datasource., Here is the code that fails:


        $error = $stm->errorInfo();
        // if($error[2]!=null)
        if ($error[0]!='00000') {
            throw new \Exception("Query Error >> [".$error[2]."] >> $query");

Here is the value it is returning:

$error = {array[3]} 
 0 = "42S02"
 1 = {int} 1146
 2 = "Table 'substantiator.survey_results_activities_temp' doesn't exist"

Now I created this temp table so I think it exists. I am not sure how to confirm that.