Advantage .NET Data Provider
Removes all records from the table and reindexes it.
public void ZapTable()
ZapTable will remove all records from the table and all data from the memo file, then the Advantage Client Engine will reindex the table. The indexes must be opened during the zap or they will become invalid. This operation requires exclusive access to the table, specified in the ConnectionString (Shared=FALSE). ZapTable is illegal in a transaction.
Note ZapTable is supported for tables only (CommandType.TableDirect). Calling ZapTable on a cursor will cause an exception.
try
{
AdsConnection conn;
AdsCommand cmd;
AdsExtendedReader rdr;
// Set shared=false so the table will be opened exclusively
conn = new AdsConnection( @"data source=c:\data; shared=false" );
conn.Open();
// Create a command that specifies just the table name (not an
// SQL statement).
cmd = new AdsCommand( "testdata", conn );
// open it as a table (not a cursor)
cmd.CommandType = CommandType.TableDirect;
rdr = cmd.ExecuteExtendedReader();
// empty the table.
rdr.ZapTable();
rdr.Close();
conn.Close();
}
catch ( Exception ex )
{
Console.WriteLine( ex.ToString() );
}
See Also