■

//テーブル関数内に作成：検証関数
public void chkdata()
{
    string repTN_BK = repTN + " _BK";
    repTN = repTN + " R";

    //_BK
    strSql = "create " + repTN_BK + " as select * from " + repTN;
    //dt = dbQ(strSql);

    //minusで差分を確認
    strSql =
        "select count(*) from" +
        " select * from " + repTN_BK +
        " minus select * from " + repTN;
    dt = dbQ(strSql);
    Console.WriteLine(dt.Rows[0][0].ToString());
    
    //XBBでREPを更新
    cmnfunc();

    //minusで差分を確認
    dt = dbQ(strSql);
    string repCNT = dt.Rows[0][0].ToString();
    Console.WriteLine("XBB⇔REP:" + repCNT + "件");

    //REPでREP_BKを更新
    xbbTN = repTN;//BKを更新
    repTN = repTN_BK + " R";
    cmnfunc();
    
    //minusで差分を確認
    dt = dbQ(strSql);
    string repBKCNT = dt.Rows[0][0].ToString();
    Console.WriteLine("REP⇔REP_BK:" + repBKCNT + ":件");

    if (repBKCNT==repCNT)
    {
        Console.WriteLine("差分なし(検証OK)");
    }
    else
    {
        Console.WriteLine("FAIL");
    }
    Console.WriteLine(repTN_BK);
}