Product Documentation

FairCom ADO.NET Driver - Developer's Guide

Previous Topic

Next Topic

Define

Define() establishes specific data definitions. This involves defining columns/fields and creating the tables/files with optional indexes.

Below is the code for Define():

//

// Define()

//

// Create the table for containing a list of existing customers

//

static void Define()

{

Console.WriteLine("DEFINE");

try

{

// create table

Console.WriteLine("\tCreate table...");

cmd.CommandText = "CREATE TABLE custmast (" +

"cm_custnumb CHAR(4)," +

"cm_custzipc CHAR(9)," +

"cm_custstat CHAR(2)," +

"cm_custrtng CHAR(1)," +

"cm_custname VARCHAR(47)," +

"cm_custaddr VARCHAR(47)," +

"cm_custcity VARCHAR(47))";

cmd.ExecuteNonQuery();

}

catch (CtreeSqlException e)

{

Handle_Exception(e);

}

catch (Exception e)

{

Handle_Exception(e);

}

try

{

cmd.CommandText = "CREATE UNIQUE INDEX cm_custnumb_idx ON custmast (cm_custnumb)";

cmd.ExecuteNonQuery();

}

catch (CtreeSqlException e)

{

Handle_Exception(e);

}

catch (Exception e)

{

Handle_Exception(e);

}

}

TOCIndex