Why am I getting ForeignKeyConst raint requires child key value error?

[dbuchanan]

Hello,

Here is the error message;
----------------------------
Exception Message:

ForeignKeyConst raint Lkp_tbl040Cmpt_ lkp302SensorTyp e requires the child
key values (5) to exist in the parent table.
----------------------------

I am encountering this error when I try to insert records into table
'tbl040Cmpt' using the DataSet1.Tables ("Table").Rows. Add(row)

The relevant data structure goes like this the table 'tbl040Cmpt'
contains a field that stores the value from lookup table
'lkp302SensorTy pe'.
Here is the relationship that exists in the Dataset;
\\
Me.Relations.Ad d("Lkp_tbl040Cm pt_lkp302Sensor Type",
Me.Tables("lkp3 02SensorType"). Columns("pkSens orTypeId"),
Me.Tables("tbl0 40Cmpt").Column s("cmSmallint06 "))
//
Here is the 'lkp302SensorTy pe' lookup table;
\\
CREATE TABLE [lkp302SensorTyp e] (
[pkSensorTypeId] [smallint] IDENTITY (1, 1) NOT NULL ,
[SensorType] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT
NULL ,
[Ord] [tinyint] NOT NULL CONSTRAINT [DF_lkp302Sensor Type_Ord] DEFAULT
(0),
[Hide] [bit] NOT NULL CONSTRAINT [DF_lkp302Sensor Type_Hide] DEFAULT
(0),
CONSTRAINT [PK_lkp302Sensor Type] PRIMARY KEY CLUSTERED
(
[pkSensorTypeId]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
//
Here are table 'tbl040Cmpt'
\\
CREATE TABLE [tbl040Cmpt] (
[pkComponentId] [char] (36) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT
NULL CONSTRAINT [DF_tbl040Cmpt_p kComponentId] DEFAULT (newid()),
[fkDevice] [char] (36) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL ,
[fkComponentType] [int] NOT NULL ,
[ComponentDescri ption] [varchar] (100) COLLATE
SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL ,
[QuanSharingConf iguration] [tinyint] NOT NULL ,
[QuanConfigured] [tinyint] NOT NULL CONSTRAINT
[DF_tbl040Cmpt_Q uanConfigured] DEFAULT (0),
[QuanActuations] [tinyint] NOT NULL CONSTRAINT
[DF_tbl040Cmpt_Q uanActuations] DEFAULT (1),
[cmVarchar01] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL
,
[cmVarchar02] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL
,
[cmVarchar03] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL
,
[cmVarchar04] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL
,
[cmVarchar05] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL
,
[cmVarchar06] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL
,
[cmNumeric01] [numeric](5, 3) NULL ,
[cmNumeric02] [numeric](5, 3) NULL ,
[cmNumeric03] [numeric](5, 3) NULL ,
[cmNumeric04] [numeric](5, 3) NULL ,
[cmNumeric05] [numeric](5, 3) NULL ,
[cmNumeric06] [numeric](5, 3) NULL ,
[cmNumeric07] [numeric](5, 3) NULL ,
[cmBit01] [bit] NULL ,
[cmBit02] [bit] NULL ,
[cmBit03] [bit] NULL ,
[cmBit04] [bit] NULL ,
[cmBit05] [bit] NULL ,
[cmBit06] [bit] NULL ,
[cmBit07] [bit] NULL ,
[cmBit08] [bit] NULL ,
[cmBit09] [bit] NULL ,
[cmBit10] [bit] NULL ,
[cmBit11] [bit] NULL ,
[cmSmallint01] [smallint] NULL ,
[cmSmallint02] [smallint] NULL ,
[cmSmallint03] [smallint] NULL ,
[cmSmallint04] [smallint] NULL ,
[cmSmallint05] [smallint] NULL ,
[cmSmallint06] [smallint] NULL ,
[cmSmallint07] [smallint] NULL ,
[cmSmallint08] [smallint] NULL ,
[cmTinyint01] [tinyint] NULL ,
[SooOrder] [numeric](5, 3) NULL ,
[SooPrecedent] [numeric](5, 3) NULL ,
[SooDelay] [numeric](5, 3) NULL ,
[SooNote] [varchar] (255) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[cmUserNote] [varchar] (255) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT
NULL ,
[cmCreatedOn] [smalldatetime] NOT NULL ,
[cmCreatedBy] [varchar] (25) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT
NULL ,
[cmEditedOn] [smalldatetime] NOT NULL ,
[cmEditedBy] [varchar] (25) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT
NULL ,
[cmrowversion] [timestamp] NOT NULL ,
CONSTRAINT [PK_tbl040Cmpt] PRIMARY KEY CLUSTERED
(
[pkComponentId]
) WITH FILLFACTOR = 90 ON [PRIMARY] ,
CONSTRAINT [FK_tbl040Cmpt_l kp202ComponentT ype] FOREIGN KEY
(
[fkComponentType]
) REFERENCES [lkp202Component Type] (
[pkComponentType Id]
),
CONSTRAINT [FK_tbl040Cmpt_t bl030Devi] FOREIGN KEY
(
[fkDevice]
) REFERENCES [tbl030Devi] (
[pkDeviceId]
) ON DELETE CASCADE NOT FOR REPLICATION
) ON [PRIMARY]
GO
//

Here is selected code that causes the error'
\\
Private Sub InsertCylnSenso r(ByVal s As String)
'Create a data row (collection of fields)
Dim row As DataRow = _dataSet1.Table s(_currentTable ).NewRow
'MessageBox.Sho w("Insert is called for: " & s)

Try
' Data entered automatically
row("pkComponen tId") = Guid.NewGuid.To String
'row("fkDevice" ) = _pkDeviceIdForF kAndParameter
row("fkDevice") = f030Devi._pkDev iceIdForFkAndPa rameter
row("fkComponen tType") = 7 'Motion sensor
' ClipDriver -
Clip Driver_1 Sensor_1 _ A(??)
row("ComponentD escription") = _
Me.txtComponent Description.Tex t.ToString & _
" - " & _componentTypeN ameForTitleAndC mptDescrip & "_" & s

row("QuanSharin gConfiguration" ) = 1
row("QuanConfig ured") = "0" 'This will be populated
OnSave after user enters data
'TODO - f041Cyln - InsertCylnSenso r - QuanActuations -
'Propagate this on to the sensors ~ is this really necessary
row("QuanActuat ions") = _quanOfComponen tActuations
'Propagate this on to the sensors

'TODO - f041Cyln - InsertCylnSenso r - row("cmVarchar0 4") =
"On"
row("cmVarchar0 4") = "On"
row("cmVarchar0 6") = _pkCmptIdOfPare ntForSensorAndP arameter

'Give all other positions a FALSE value and only the proper
position a TRUE value
' This allows proper filtering
row("cmBit01") = False 'B
row("cmBit02") = False 'D
row("cmBit04") = False 'C
row("cmBit05") = False 'A

Select Case s
Case "B"
row("cmBit01") = True 'B
Case "D"
row("cmBit02") = True 'D
Case "C"
row("cmBit04") = True 'C
Case "A"
row("cmBit05") = True 'A
End Select

row("cmBit06") = True 'PNP NON
row("cmBit07") = True 'is Motion sensor

row("cmSmallint 01") = 1
'Me.cboSensorVo ltage.NSelected Value ~ (1 = 24 volt)
'cmSmallint02
'cmSmallint03
'cmSmallint04
'cmSmallint05
row("cmSmallint 06") = 5 'Me.cboSensorTy pe.NSelectedVal ue
~ (5 = Hall effect)
'cmSmallint07
row("cmSmallint 08") = 2
'Me.cboSensorCo nnection.NSelec tedValue ~ (2 = Micro)

row("cmUserNote ") = ""
row("cmCreatedO n") = Now.ToString
row("cmCreatedB y") = SystemInformati on.UserName.ToS tring
row("cmEditedOn ") = Now.ToString
row("cmEditedBy ") = SystemInformati on.UserName.ToS tring

' The following data is entered by the user - later
'row("cmVarchar 01") = ucase(Me.txtSen sorIOAddress.Te xt)

' The following data is confirmed by the user - later
'row("cmBit06") = True 'PNP NON

Catch ane As ArgumentNullExc eption
'The exception that is thrown when a null reference
(Nothing in Visual Basic) is passed to a method that does 'not accept
it as a valid argument.
Throw New DBAccessExcepti on("You are passing a 'Nothing' as
a parameter to a method where an actual value is required.", ane)
Catch ce As ConstraintExcep tion
'Represents the exception that is thrown when attempting an
action that violates a constraint.
Throw New DBAccessExcepti on("You have attempted an action
that violates a constraint.", ce)
Catch e As Exception
'Represents errors that occur during application execution.
Throw New DBAccessExcepti on("An unanticipated exception has
ocurred.", e)
End Try
Try
_dataSet1.Table s(_currentTable ).Rows.Add(row) '<<<This
line causes the error
Catch diee As Data.InvalidExp ressionExceptio n
'Represents the exception that is thrown when attempting to
add a DataColumn
Throw New DBAccessExcepti on("The data column you are
attempting to add contains an error.", diee)
Catch dsee As SyntaxErrorExce ption
'Represents the exception that is thrown when the
Expression property of a DataColumn contains a syntax error.
Throw New DBAccessExcepti on("The data column you are
attempting to add contains a syntax error.", dsee)
Catch e As Exception
MessageBox.Show ("Exception Message: " & vbCrLf & e.Message)
MessageBox.Show ("Exception Source: " & vbCrLf & e.Source)
MessageBox.Show ("Exception StackTrace: " & vbCrLf &
e.StackTrace)
'Represents errors that occur during application execution.
'Throw New DBAccessExcepti on("An unanticipated exception
has ocurred.", e)
End Try

End Sub
//
The error says
ForeignKeyConst raint Lkp_tbl040Cmpt_ lkp302SensorTyp e requires the child
key values (5) to exist in the parent table.

The "5" is the value that is given to the field cmSmallint06 in the
line shown here;
\\
row("cmSmallint 06") = 5 'Me.cboSensorTy pe.NSelectedVal ue ~ (5 =
Hall effect)
//

I don't understand why I am getting this error when I am passing the
required value. Can someone explain what might be casusing this?

(5 = Hall effect)

Please help me.

Thank you,
dbuchanan

[Cor Ligthert [MVP]]

Dbuchan,

AFAIK, does it says that there is one or more child rows from which the
related key does not exist in your parent datatable while it does in the
child, so it cannot set the relation to the parent.

That is all.

Cor

[dbuchanan]

Cor,

I am having difficulty understanding your post.

"does is says" > does it SAY

does *what* say? my code?, the error?

"one or more child rows" (?) are you saying you think the error is
about "one or more child rows" - no the error does not say anything
about one or more rows, just about child key values.
That value is (5) because that is what I assigned to it. See the code.

"related key does not exist" - no there is nothing missing in the
relationship. The relationship *is* correctly composed. If it were not
the code would not compile. I would get the squiggly lines.

It is difficult for me to understand your post. ~ There is one
relationship between the table and the lookup table for the field
'cmSmallint06'. and it is correctly composed. Please review my post
again.

Thank you,
dbuchanan

[Sahil Malik [MVP]]

> "related key does not exist" - no there is nothing missing in the

relationship. The relationship *is* correctly composed. If it were not
the code would not compile. I would get the squiggly lines.
The relationship is indeed set correctly - atleast as far as the compiler is
concerned, but at the time you are adding the relationship to your dataset,
the dataset at that time contains certain offending rows where the foreign
key is not satisfied. The problem is not in your code, it's in the data that
is loaded in the dataset.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------

"dbuchanan" <db*********@ho tmail.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com... Cor,

I am having difficulty understanding your post.

"does is says" > does it SAY

does *what* say? my code?, the error?

"one or more child rows" (?) are you saying you think the error is
about "one or more child rows" - no the error does not say anything
about one or more rows, just about child key values.
That value is (5) because that is what I assigned to it. See the code.

"related key does not exist" - no there is nothing missing in the
relationship. The relationship *is* correctly composed. If it were not
the code would not compile. I would get the squiggly lines.

It is difficult for me to understand your post. ~ There is one
relationship between the table and the lookup table for the field
'cmSmallint06'. and it is correctly composed. Please review my post
again.

Thank you,
dbuchanan

[Cor Ligthert [MVP]]

dbuchanan,

"does is says" > does it SAY

Can you tell me where I wrote that quoted text that you don't understand?

I cannot find it in the text, that I have showed you.

Cor

[Sahil Malik [MVP]]

Hope your news reader can do HTML .. see below

- SM

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:u9******** ******@TK2MSFTN GP09.phx.gbl...

Dbuchan,

AFAIK, does it says that there is one or more child rows from which the
related key does not exist in your parent datatable while it does in the
child, so it cannot set the relation to the parent.

That is all.

Cor

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:en******** *****@TK2MSFTNG P10.phx.gbl... dbuchanan,

"does is says" > does it SAY

Can you tell me where I wrote that quoted text that you don't understand?

I cannot find it in the text, that I have showed you.

Cor

[Cor Ligthert [MVP]]

That is not what Dbuchan told that I wrote.

Cor

"Sahil Malik [MVP]" <co************ *****@nospam.co m> schreef in bericht news:e3******** ******@TK2MSFTN GP14.phx.gbl...
Hope your news reader can do HTML .. see below

- SM

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:u9******** ******@TK2MSFTN GP09.phx.gbl...

Dbuchan,

AFAIK, does it says that there is one or more child rows from which the
related key does not exist in your parent datatable while it does in the
child, so it cannot set the relation to the parent.

That is all.

Cor

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:en******** *****@TK2MSFTNG P10.phx.gbl... dbuchanan,

"does is says" > does it SAY

Can you tell me where I wrote that quoted text that you don't understand?

I cannot find it in the text, that I have showed you.

Cor

[dbuchanan]

Sahil,

Thank you for your reply.

The problem is not in your code, it's in the data that is loaded in the dataset.

If you are saying data that is existing in the database - That is not
exactly true because the relationship is present before the data is
filled (loaded) in the form. The relationship is present before the
data is loaded - it is defined in the dataset.

The data fills (loads into) the form while the relationship in place
without an error ocurring. The error occurs at the time when a new row
is added. Here is the line that causes the error;

\\
_dataSet1.Table s(_currentTable ).Rows.Add(row)
//

Because this line causes the error it seems to imply that the data I am
sending does not supply the value required to satisfy the relationship.
However the required value *is* supplied!

Below is the data I am sending (Cleaned up for clarity). I have
indicated the statement where the value is assigned to the required
field.

\\
row("pkComponen tId") = Guid.NewGuid.To String
row("fkDevice") = "39128253-37fd-4c8f-9bea-c13db0c2cacc"
row("fkComponen tType") = 7
row("ComponentD escription") = "Cyl - Degate - Cyln - MSens_B"
row("QuanSharin gConfiguration" ) = 1
row("QuanConfig ured") = "0"
row("QuanActuat ions") = "1"
row("cmVarchar0 4") = "On"
row("cmVarchar0 4") = "On"
row("cmVarchar0 6") = "08795d8a-1669-4991-87ac-a6fffcb683e5"
row("cmBit01") = False
row("cmBit02") = False
row("cmBit04") = False
row("cmBit05") = False

Select Case s
Case "B"
row("cmBit01") = True
Case "D"
row("cmBit02") = True
Case "C"
row("cmBit04") = True
Case "A"
row("cmBit05") = True
End Select

row("cmBit06") = True
row("cmBit07") = True
row("cmSmallint 01") = 1
row("cmSmallint 06") = 5 '(5 = Hall effect) <<< This where the required
value is assigned.
row("cmSmallint 08") = 2
row("cmUserNote ") = ""
row("cmCreatedO n") = Now.ToString
row("cmCreatedB y") = SystemInformati on.UserName.ToS tring
row("cmEditedOn ") = Now.ToString
row("cmEditedBy ") = SystemInformati on.UserName.ToS tring
//

The question remains ~ Why am I getting this error?

dbuchanan

[Sahil Malik [MVP]]

Okay the below code is much smaller than the previous wall of ascii, so it's
actually something I can read.

Could you verify for me if ..

cmSmallint06 <-- the datatypes of the column in both tables?
the definition of the datarelation
the fact that "5" exists in the other datatable at the moment you are trying
to add that row.

I am *quite* certain that the error is in your data, I'm just trying to zero
in on what specific data :).

If all else fails, could you help me help you by letting me recreate your
error easily at my end by

a) Right before the add(row) statement, please do
dataset1.writex ml(datafile), dataset1.writex mlschema(schema file) <-- attach
these 2 files with the reply
b) a real teenie weenie code sample, hopefully less than 15 lines ;) which
loads the above schemafile and data file in a new dataset, and attempts to
load the row - and hence recreates the error in a rather simple manner
(rather than me having to setup the database etc. on my end - hey I do have
another job) :).

Once I can recreate your world on my desktop, I think I'll be easily able to
point you to the specific error.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------

"dbuchanan" <db*********@ho tmail.com> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. .

Sahil,

Thank you for your reply.

The problem is not in your code, it's in the data that is loaded in the
dataset.

If you are saying data that is existing in the database - That is not
exactly true because the relationship is present before the data is
filled (loaded) in the form. The relationship is present before the
data is loaded - it is defined in the dataset.

The data fills (loads into) the form while the relationship in place
without an error ocurring. The error occurs at the time when a new row
is added. Here is the line that causes the error;

\\
_dataSet1.Table s(_currentTable ).Rows.Add(row)
//

Because this line causes the error it seems to imply that the data I am
sending does not supply the value required to satisfy the relationship.
However the required value *is* supplied!

Below is the data I am sending (Cleaned up for clarity). I have
indicated the statement where the value is assigned to the required
field.

\\
row("pkComponen tId") = Guid.NewGuid.To String
row("fkDevice") = "39128253-37fd-4c8f-9bea-c13db0c2cacc"
row("fkComponen tType") = 7
row("ComponentD escription") = "Cyl - Degate - Cyln - MSens_B"
row("QuanSharin gConfiguration" ) = 1
row("QuanConfig ured") = "0"
row("QuanActuat ions") = "1"
row("cmVarchar0 4") = "On"
row("cmVarchar0 4") = "On"
row("cmVarchar0 6") = "08795d8a-1669-4991-87ac-a6fffcb683e5"
row("cmBit01") = False
row("cmBit02") = False
row("cmBit04") = False
row("cmBit05") = False

Select Case s
Case "B"
row("cmBit01") = True
Case "D"
row("cmBit02") = True
Case "C"
row("cmBit04") = True
Case "A"
row("cmBit05") = True
End Select

row("cmBit06") = True
row("cmBit07") = True
row("cmSmallint 01") = 1
row("cmSmallint 06") = 5 '(5 = Hall effect) <<< This where the required
value is assigned.
row("cmSmallint 08") = 2
row("cmUserNote ") = ""
row("cmCreatedO n") = Now.ToString
row("cmCreatedB y") = SystemInformati on.UserName.ToS tring
row("cmEditedOn ") = Now.ToString
row("cmEditedBy ") = SystemInformati on.UserName.ToS tring
//

The question remains ~ Why am I getting this error?

dbuchanan

[dbuchanan]

Hi Sahil,

Here is the verification, dataset and dataschema you requested;

cmSmallint06 <-- the datatypes of the column in both tables?
Here are partial definitions for the tables;
\\
CREATE TABLE [lkp302SensorTyp e] (
[pkSensorTypeId] [smallint] IDENTITY (1, 1) NOT NULL ,
...
//
\\
CREATE TABLE [tbl040Cmpt] (
...
[cmSmallint06] [smallint] NULL ,
...
//

the definition of the datarelation
Here is the relation
\\
Me.Relations.Ad d("Lkp_tbl040Cm pt_lkp302Sensor Type",
Me.Tables("lkp3 02SensorType"). Columns("pkSens orTypeId"),
Me.Tables("tbl0 40Cmpt").Column s("cmSmallint06 "))
//
the fact that "5" exists in the other datatable at the moment you are trying
to add that row.

Here is the data contained in lkp302SensorTyp e in the form of CSV;
\\
pkSensorTypeId, SensorType,Ord, Hide
1,"Bar Code",1,False
2,"Capacitive", 2,False
3,"Color",3,Fal se
4,"Diffuse",4,F alse
5,"Hall Effect",5,False
6,"Inductive",6 ,False
7,"Limit Switch",7,False
8,"Pressure",8, False
9,"Reed",9,Fals e
10,"Retro-Reflective",10, False
11,"Through Beam",11,False
12,"Ultrasonic" ,12,False
//

Here is the dataset;
\\
<?xml version="1.0" standalone="yes "?>
<NewDataSet>
<tbl040Cmpt>
<pkComponentId> 8bf25abb-cb5d-40ec-8e37-2baf565a3cde</pkComponentId>
<fkDevice>9fbbd 7c8-a833-48a1-8036-f2fb5c02a718</fkDevice>
<fkComponentTyp e>2</fkComponentType >
<ComponentDescr iption>Cyl - Clip Driver -
Cyln</ComponentDescri ption>
<QuanSharingCon figuration>4</QuanSharingConf iguration>
<QuanConfigured >4</QuanConfigured>
<QuanActuations >1</QuanActuations>
<cmVarchar04>(s ee valve)</cmVarchar04>
<cmNumeric02>1. 500</cmNumeric02>
<cmNumeric03>2. 000</cmNumeric03>
<cmNumeric04>0. 375</cmNumeric04>
<cmNumeric05>1. 000</cmNumeric05>
<cmNumeric07>3. 162</cmNumeric07>
<cmBit01>fals e</cmBit01>
<cmBit02>fals e</cmBit02>
<cmBit04>true </cmBit04>
<cmBit05>fals e</cmBit05>
<cmBit07>true </cmBit07>
<cmBit08>true </cmBit08>
<cmBit09>fals e</cmBit09>
<cmBit10>true </cmBit10>
<cmSmallint05>1 </cmSmallint05>
<cmTinyint01> 0</cmTinyint01>
<cmUserNote />
<cmCreatedOn>20 05-11-27T16:28:00.000 0000-05:00</cmCreatedOn>
<cmCreatedBy>db uchanan</cmCreatedBy>
<cmEditedOn>200 5-11-27T16:28:00.000 0000-05:00</cmEditedOn>
<cmEditedBy>dbu chanan</cmEditedBy>
<cmrowversion>A AAAAAAAxzI=</cmrowversion>
</tbl040Cmpt>
<lkp101PortSize >
<pkPortSizeId>7 </pkPortSizeId>
<PortSize>1/8 G</PortSize>
<Ord>1</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>1 </pkPortSizeId>
<PortSize>1/8 NPT</PortSize>
<Ord>1</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>2 </pkPortSizeId>
<PortSize>10-32 Straight</PortSize>
<Ord>2</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>8 </pkPortSizeId>
<PortSize>1/4 G</PortSize>
<Ord>3</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>3 </pkPortSizeId>
<PortSize>1/4 NPT</PortSize>
<Ord>3</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>9 </pkPortSizeId>
<PortSize>3/8 G</PortSize>
<Ord>4</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>4 </pkPortSizeId>
<PortSize>3/8 NPT</PortSize>
<Ord>4</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>1 0</pkPortSizeId>
<PortSize>1/2 G</PortSize>
<Ord>5</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>5 </pkPortSizeId>
<PortSize>1/2 NPT</PortSize>
<Ord>5</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>1 1</pkPortSizeId>
<PortSize>3/4 G</PortSize>
<Ord>6</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>6 </pkPortSizeId>
<PortSize>3/4 NPT</PortSize>
<Ord>6</Ord>
<Hide>false</Hide>
</lkp101PortSize>
</NewDataSet>
//

Here is the schemafile
\\
<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="tbl010Job ">
<xs:complexType >
<xs:sequence>
<xs:element name="pkJobId" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="JobNumber ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CustomerN ame">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="35" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="JobDescri ption">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="75" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Reference JobNumber" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ShopPsi" type="xs:unsign edByte"
minOccurs="0" />
<xs:element name="SystemVol tage" type="xs:short"
minOccurs="0" />
<xs:element name="SystemPha se" type="xs:short"
minOccurs="0" />
<xs:element name="SystemAmp s" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="HasCircui tBreakersYN" type="xs:boolea n"
/>
<xs:element name="AllProces sesAddedYN" type="xs:boolea n"
/>
<xs:element name="AllTasksA ddedYN" type="xs:boolea n" />
<xs:element name="AllProces sesConfiguredYN "
type="xs:boolea n" />
<xs:element name="ApprovedY N" type="xs:boolea n" />
<xs:element name="Completed YN" type="xs:boolea n" />
<xs:element name="IsMasterY N" type="xs:boolea n" />
<xs:element name="Archive" type="xs:boolea n" />
<xs:element name="jcUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="jcCreated On" type="xs:dateTi me" />
<xs:element name="jcCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="jcEditedO n" type="xs:dateTi me" />
<xs:element name="jcEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="jcrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl020Pro c">
<xs:complexType >
<xs:sequence>
<xs:element name="pkProcess Id" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkJob">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkDeviceT ype" type="xs:int" />
<xs:element name="QuanIndiv idualProcesses"
type="xs:unsign edByte" />
<xs:element name="QuanIndiv idualProcessesC onfigured"
type="xs:unsign edByte" />
<xs:element name="mpUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="mpCreated On" type="xs:dateTi me" />
<xs:element name="mpCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="mpEditedO n" type="xs:dateTi me" />
<xs:element name="mpEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="mprowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl030Dev i">
<xs:complexType >
<xs:sequence>
<xs:element name="pkDeviceI d" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkProcess ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DeviceDes cription">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QuanOfAct uations"
type="xs:unsign edByte" />
<xs:element name="CustomDev iceYN" type="xs:boolea n" />
<xs:element name="QuanCylin ders" type="xs:unsign edByte"
/>
<xs:element name="QuanValve s" type="xs:unsign edByte" />
<xs:element name="QuanSenso rs" type="xs:unsign edByte" />
<xs:element name="QuanAirSe rvices" type="xs:unsign edByte"
/>
<xs:element name="QuanElect Services"
type="xs:unsign edByte" />
<xs:element name="QuanHMIs" type="xs:unsign edByte" />
<xs:element name="QuanCylin dersConfigured"
type="xs:unsign edByte" />
<xs:element name="QuanValve sConfigured"
type="xs:unsign edByte" />
<xs:element name="QuanSenso rsConfigured"
type="xs:unsign edByte" />
<xs:element name="QuanAirSe rvicesConfigure d"
type="xs:unsign edByte" />
<xs:element name="QuanElect ServicesConfigu red"
type="xs:unsign edByte" />
<xs:element name="QuanHMIsC onfigured"
type="xs:unsign edByte" />
<xs:element name="QuanMotio nSensorsConfigu red"
type="xs:unsign edByte" />
<xs:element name="DeviceCon figCompleteYN"
type="xs:boolea n" />
<xs:element name="dsUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dsCreated On" type="xs:dateTi me" />
<xs:element name="dsCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dsEditedO n" type="xs:dateTi me" />
<xs:element name="dsEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dsrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl040Cmp t">
<xs:complexType >
<xs:sequence>
<xs:element name="pkCompone ntId" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkDevice" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkCompone ntType" type="xs:int" />
<xs:element name="Component Description">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QuanShari ngConfiguration "
type="xs:unsign edByte" />
<xs:element name="QuanConfi gured" type="xs:unsign edByte"
/>
<xs:element name="QuanActua tions" type="xs:unsign edByte"
/>
<xs:element name="cmVarchar 01" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 02" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 03" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 04" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 05" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 06" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmNumeric 01" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 02" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 03" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 04" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 05" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 06" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 07" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmBit01" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit02" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit03" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit04" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit05" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit06" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit07" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit08" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit09" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit10" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit11" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmSmallin t01" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t02" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t03" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t04" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t05" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t06" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t07" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t08" type="xs:short"
minOccurs="0" />
<xs:element name="cmTinyint 01" type="xs:short"
minOccurs="0" />
<xs:element name="SooOrder" type="xs:decima l"
minOccurs="0" />
<xs:element name="SooPreced ent" type="xs:decima l"
minOccurs="0" />
<xs:element name="SooDelay" type="xs:decima l"
minOccurs="0" />
<xs:element name="SooNote" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmCreated On" type="xs:dateTi me" />
<xs:element name="cmCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmEditedO n" type="xs:dateTi me" />
<xs:element name="cmEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl050Ope r">
<xs:complexType >
<xs:sequence>
<xs:element name="pkOperId" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqfkJob">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqCompone ntDescription">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqAction" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqDuratio n" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqSooOrde r" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqSooPrec edent" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqSooDela y" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqIOAddre ss" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqSooNote " minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqCreated On" type="xs:dateTi me" />
<xs:element name="sqCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqEditedO n" type="xs:dateTi me" />
<xs:element name="sqEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblUnion1 ">
<xs:complexType >
<xs:sequence>
<xs:element name="pkID_u1" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkJob_u1" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="tbl_u1" type="xs:short" />
<xs:element name="cmptDescr iption_u1">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Action_u1 " minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Duration_ u1" type="xs:decima l"
minOccurs="0" />
<xs:element name="Order_u1" type="xs:decima l"
minOccurs="0" />
<xs:element name="Precedent _u1" type="xs:unsign edByte"
minOccurs="0" />
<xs:element name="Delay_u1" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IOAddress _u1" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Note_u1" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CreatedOn _u1" type="xs:dateTi me" />
<xs:element name="CreatedBy _u1">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="EditedOn_ u1" type="xs:dateTi me" />
<xs:element name="EditedBy_ u1">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="rowversio n_u1" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblUseAud it">
<xs:complexType >
<xs:sequence>
<xs:element name="ClipUser" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Computer" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ClipVersi on">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DateTime" type="xs:dateTi me" />
<xs:element name="Selection ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lst00Mast erList">
<xs:complexType >
<xs:sequence>
<xs:element name="pkMasterL istId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:int" />
<xs:element name="TableName ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FriendlyN ame">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="UserInstr uction" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lst002Vie wList">
<xs:complexType >
<xs:sequence>
<xs:element name="pkViewLis tId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:int" />
<xs:element name="ViewName" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="prefix">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp101Por tSize">
<xs:complexType >
<xs:sequence>
<xs:element name="pkPortSiz eId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="PortSize" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp102Pha se">
<xs:complexType >
<xs:sequence>
<xs:element name="pkPhaseId " msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="Phase">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp103Sen sorConnection">
<xs:complexType >
<xs:sequence>
<xs:element name="pkSensorC onnectionId"
msdata:ReadOnly ="true" msdata:AutoIncr ement="true"
msdata:AutoIncr ementSeed="-1" msdata:AutoIncr ementStep="-1"
type="xs:short" />
<xs:element name="SensorCon nection">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp104Vol tage">
<xs:complexType >
<xs:sequence>
<xs:element name="pkVoltage Id" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="Voltage">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp105Pan elLocation">
<xs:complexType >
<xs:sequence>
<xs:element name="pkPanelLo cationId"
msdata:ReadOnly ="true" msdata:AutoIncr ement="true"
msdata:AutoIncr ementSeed="-1" msdata:AutoIncr ementStep="-1"
type="xs:short" />
<xs:element name="PanelLoca tion">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp201Dev iceType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkDeviceT ypeId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:int" />
<xs:element name="DeviceNam e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Prefix">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Valve" type="xs:boolea n" />
<xs:element name="Cylinder" type="xs:boolea n" />
<xs:element name="Sensors" type="xs:boolea n" />
<xs:element name="AirServ" type="xs:boolea n" />
<xs:element name="ElecServ" type="xs:boolea n" />
<xs:element name="HMI" type="xs:boolea n" />
<xs:element name="Note">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp202Com ponentType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkCompone ntTypeId"
msdata:ReadOnly ="true" msdata:AutoIncr ement="true"
msdata:AutoIncr ementSeed="-1" msdata:AutoIncr ementStep="-1"
type="xs:int" />
<xs:element name="Component Name">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Prefix">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp301Val veType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkValveTy peId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="ValveType ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp302Sen sorType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkSensorT ypeId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="SensorTyp e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp303Hmi Type">
<xs:complexType >
<xs:sequence>
<xs:element name="pkHmiType Id" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="HmiType">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ION">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constrain t1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl010Job" />
<xs:field xpath="pkJobId" />
</xs:unique>
<xs:unique name="tbl020Pro c_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl020Proc" />
<xs:field xpath="pkProces sId" />
</xs:unique>
<xs:unique name="tbl030Dev i_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl030Devi" />
<xs:field xpath="pkDevice Id" />
</xs:unique>
<xs:unique name="tbl040Cmp t_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="pkCompon entId" />
</xs:unique>
<xs:unique name="tbl050Ope r_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl050Oper" />
<xs:field xpath="pkOperId " />
</xs:unique>
<xs:unique name="tblUnion1 _Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tblUnion1" />
<xs:field xpath="pkID_u1" />
</xs:unique>
<xs:unique name="lst00Mast erList_Constrai nt1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lst00MasterList " />
<xs:field xpath="pkMaster ListId" />
</xs:unique>
<xs:unique name="lst002Vie wList_Constrain t1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lst002ViewList" />
<xs:field xpath="pkViewLi stId" />
</xs:unique>
<xs:unique name="lkp101Por tSize_Constrain t1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp101PortSize" />
<xs:field xpath="pkPortSi zeId" />
</xs:unique>
<xs:unique name="lkp102Pha se_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp102Phase" />
<xs:field xpath="pkPhaseI d" />
</xs:unique>
<xs:unique name="lkp103Sen sorConnection_C onstraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp103SensorCon nection" />
<xs:field xpath="pkSensor ConnectionId" />
</xs:unique>
<xs:unique name="lkp104Vol tage_Constraint 1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp104Voltage" />
<xs:field xpath="pkVoltag eId" />
</xs:unique>
<xs:unique name="lkp105Pan elLocation_Cons traint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp105PanelLoca tion" />
<xs:field xpath="pkPanelL ocationId" />
</xs:unique>
<xs:unique name="lkp201Dev iceType_Constra int1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp201DeviceTyp e" />
<xs:field xpath="pkDevice TypeId" />
</xs:unique>
<xs:unique name="lkp202Com ponentType_Cons traint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp202Component Type" />
<xs:field xpath="pkCompon entTypeId" />
</xs:unique>
<xs:unique name="lkp301Val veType_Constrai nt1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp301ValveType " />
<xs:field xpath="pkValveT ypeId" />
</xs:unique>
<xs:unique name="lkp302Sen sorType_Constra int1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp302SensorTyp e" />
<xs:field xpath="pkSensor TypeId" />
</xs:unique>
<xs:unique name="lkp303Hmi Type_Constraint 1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp303HmiType" />
<xs:field xpath="pkHmiTyp eId" />
</xs:unique>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp103Sen sorConnection"
refer="lkp103Se nsorConnection_ Constraint1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt08" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp303Hmi Type"
refer="lkp303Hm iType_Constrain t1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt07" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp302Sen sorType"
refer="lkp302Se nsorType_Constr aint1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt06" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp101Por tSize"
refer="lkp101Po rtSize_Constrai nt1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt05" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp301Val veType"
refer="lkp301Va lveType_Constra int1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt04" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp105Pan elLocation"
refer="lkp105Pa nelLocation_Con straint1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt03" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp102Pha se"
refer="lkp102Ph ase_Constraint1 ">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt02" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp104Vol tage"
refer="lkp104Vo ltage_Constrain t1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt01" />
</xs:keyref>
<xs:keyref name="FK_tbl020 Proc_lkp201Devi ceType"
refer="lkp201De viceType_Constr aint1">
<xs:selector xpath=".//tbl020Proc" />
<xs:field xpath="fkDevice Type" />
</xs:keyref>
<xs:keyref name="FK_tbl010 Job_lkp102Phase "
refer="lkp102Ph ase_Constraint1 ">
<xs:selector xpath=".//tbl010Job" />
<xs:field xpath="SystemPh ase" />
</xs:keyref>
<xs:keyref name="FK_tbl010 Job_lkp104Volta ge"
refer="lkp104Vo ltage_Constrain t1">
<xs:selector xpath=".//tbl010Job" />
<xs:field xpath="SystemVo ltage" />
</xs:keyref>
</xs:element>
</xs:schema>
//

Thank you,
dbuchanan