//find tool by toolnumber
int sql_tool_by_toolno(int toolno, CANON_TOOL_TABLE* tool){
    printf("sql_tool_by_toolno %i\n",toolno);
    int rc;
    rc = sqlite3_prepare_v2(db, "select tool,pocket,X,Y,Z,A,B,C,U,V,W,D,orientation,frontangle,backangle from tools where tool = ?1;", -1, &stmt, NULL);
    sqlite3_bind_int(stmt, 1, toolno);
    if(sqlite3_step(stmt) ==  SQLITE_ROW){
        tool->toolno        = sqlite3_column_int(stmt, 0);
        tool->pocketno      = sqlite3_column_int(stmt, 1);
        tool->offset.tran.x = sqlite3_column_double(stmt, 2);
        tool->offset.tran.y = sqlite3_column_double(stmt, 3);
        tool->offset.tran.z = sqlite3_column_double(stmt, 4);
        tool->offset.a      = sqlite3_column_double(stmt, 5);
        tool->offset.b      = sqlite3_column_double(stmt, 6);
        tool->offset.c      = sqlite3_column_double(stmt, 7);
        tool->offset.u      = sqlite3_column_double(stmt, 8);
        tool->offset.v      = sqlite3_column_double(stmt, 9);
        tool->offset.w      = sqlite3_column_double(stmt, 10);
        tool->diameter      = sqlite3_column_double(stmt, 11);
        tool->frontangle    = sqlite3_column_double(stmt, 12);
        tool->backangle     = sqlite3_column_double(stmt, 13);
        tool->orientation   = sqlite3_column_int(stmt, 14);
        printf("sql: found tool %i in pocket %i len %f diam %f\n",tool->toolno,tool->pocketno,tool->offset.tran.z,tool->diameter);
    }else{
        printf("sql: not found\n");
    }

    sqlite3_finalize(stmt);
}