ArcGISCompare.msAccProcs.BuildMappingTables C# (CSharp) Method

BuildMappingTables() public method

public BuildMappingTables ( ) : System.Boolean
return System.Boolean
        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;
              }
        }