Advantage .NET Data Provider
Converts a table structure and associated records to a new table of a different type.
public void ConvertTable( FilterOption filtOpt, String strFile, TableType tableType );
Converts a table structure and associated records to a new table of the given TableType. The new table will contain data types that are capable of storing the information, but the data types may change. For example, when converting from a DBF to an ADT, ADS_NUMERIC fields are converted to ADS_SHORTINT, ADS_INTEGER, or ADS_DOUBLE fields depending upon the size and decimals of the original numeric field.
Whenever conversions to DBF files are performed, the new DBF table will contain only standard DBF field types if possible. These data types include only ADS_LOGICAL, ADS_NUMERIC, ADS_STRING, and ADS_DATE.
The records copied to the new table depend on the option set by the given FilterOption.
Index files will not be copied as they can be created after the conversion. The resulting table must be opened by the application after the convert table operation is performed before the application can use the table. ConvertTable will not attempt to convert tables on the server; the client always performs this operation.
Note This function is illegal in a transaction.
See Also