n_flushtx() - SQL interface

SYNOPSIS

int n_flushtx(se,tx);
SERVER  *se;
TX      *tx;

DESCRIPTION
This function flushes any remaining results from the current SQL statement. Execution of the statement is finished however. This is useful for ignoring the output of INSERT and DELETE statements.

EXAMPLE

SERVER *se;

   ...
                                                     /* setup query */
   if(n_settx(se,tx,
              "delete from customer where lastorder<'1990-01-01';"
             )!=TXPN)
      n_flushtx(se,tx);                        /* ignore result set */
   ...