public Boolean BuildMappingTables()
{
OleDbCommand theCMD;
String theSQL = "";
try
{
checkOpen();
theSQL = "CREATE TABLE [FeatureMappings] ([SerialNumber] long, [srcGeodatabase] varchar(255), [sourceClass] varchar(45), [destinationClass] varchar(45), [sourceGeom] long, [destinationGeom] long, [geomTransform] long, [featureCount] long)";
theCMD = new OleDbCommand(theSQL, theConn);
theCMD.ExecuteNonQuery();
checkOpen();
theSQL = "CREATE TABLE [AttributeMappings] ([SerialNumber] long, [sourceClass] varchar(45), [destinationClass] varchar(45), [sourceField] varchar(45), [sourceDT] long, [sourceLength] long, [sourceEnum] varchar(45), [destinationField] varchar(45), [destinationDT] long, [destinationLength] long, [destinationEnum] varchar(45), [valueCount] long, [constant] varchar(255), [results] memo, [transform] long)";
theCMD = new OleDbCommand(theSQL, theConn);
theCMD.ExecuteNonQuery();
checkOpen();
theSQL = "CREATE TABLE [ValueMappings] ([srcEnumName] varchar(45), [destEnumName] varchar(45), [sourceValue] varchar(100), [destinationValue] varchar(100), [valueCount] long)";
theCMD = new OleDbCommand(theSQL, theConn);
theCMD.ExecuteNonQuery();
checkOpen();
theSQL = "CREATE TABLE [FeatureLoadProblems] ([SerialNumber] long, [GeodatabaseName] varchar(100), [sourceClass] varchar(45), [destinationClass] varchar(45), [srcObjectID] long, [problemDescription] memo)";
theCMD = new OleDbCommand(theSQL, theConn);
theCMD.ExecuteNonQuery();
checkOpen();
theSQL = "CREATE TABLE [DataLossProblems] ([SerialNumber] int, [sourceClass] varchar(45), [destinationClass] varchar(45), [sourceFieldName] varchar(45), [srcObjectID] long, [dataLoadError] memo)";
theCMD = new OleDbCommand(theSQL, theConn);
theCMD.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
return false;
}
}