<< Click to Display Table of Contents >> Navigation:  »No topics above this level« C Examples: DbiEmptyTable

Creates a copy of a source table, then empties it. Both tables must be of the same type. This example uses the following input:
         fDbiEmptyTable(hDb, "CUSTOMER.DB", "NEW CUSTOMER.DB");

DBIResult fDbiEmptyTable(hDBIDb hTmpDb, pCHAR szSrcTblName, pCHAR szDstTblName)

{

   DBIResult rslt;

   hDBICur hCursor = 0;

 

   // Creating a dummy table to empty.

   rslt = Chk(DbiCopyTable(hTmpDb, TRUE, szSrcTblName, dbiNOLOCK, szDstTblName));

   if (rslt != DBIERR_NONE)

      return rslt;

   // Open the dummy table so it can be emptied.

   rslt = Chk(DbiOpenTable(hTmpDb, szDstTblName, NULL, NULL, NULL, 0, dbiREADWRITE,

               dbiOPENEXCL, xltFIELD, FALSE, NULL, &hCursor));

   if (rslt != DBIERR_NONE)

      return rslt;

   rslt = Chk(DbiEmptyTable(hTmpDb, hCursor, NULL, NULL));

   if (rslt != DBIERR_NONE)

      return rslt;

 

   rslt = Chk(DbiCloseCursor(&hCursor));

   if (rslt != DBIERR_NONE)

      return rslt;

 

   return rslt;

}