473,597 Members | 2,238 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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

Nov 28 '05 #1
13 10118
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
Nov 28 '05 #2
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

Nov 28 '05 #3
> "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

Nov 29 '05 #4
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
Nov 29 '05 #5
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

Nov 29 '05 #6
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

Nov 29 '05 #7
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

Nov 29 '05 #8
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

Nov 29 '05 #9
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

Nov 29 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
3957
by: fotzor | last post by:
Hi, I'm a C++-Programmer and want to subclass the Edit used to write a SQL-Query in Access. The edit is of the special Access class OKttbx. Everything works, I injected a DLL into the Access-Process and the subclassing works but I can't get the Windowtext of the control...I tried the WM_GETTEXT message but it seems that Microsoft uses another way to get the text the user typed in. Has somebody an idea how I can get this to work? mfg...
2
5972
by: Sam | last post by:
In our C++ program, we are using the system call to execute another C++ program synchronously. The program executed by system runs without error and returns back a 0. Under conditions we cannot determine, the system function will return back a 128 even though the command executed exited with a return code of 0. I found in the Winerror.h, that 128 means
0
1706
by: Benny Raymond | last post by:
reply to: benny@pocketrocks.com if possible: I'm trying to set up a hierarchy system in this database where each row can be related to a previous row. The problem is that when I go to addTreeRow, it doesn't allow me to use Convert.DBNull for the childof column, even though I have nilable set to true. (All parent nodes have to be set to null, since they are not the child of any other row... especially the very first row, which will have...
1
2647
by: jaYPee | last post by:
I have created 3 sqldataadapter. each adapter.selectcommand has a parameter. I have added a textbox to supply a value for each parameter. My problem is when I press enter the second time to fire up the keypress event from the textbox I recieved this error in datagrid object "ForeignKeyConstraint StudentsSchYrSem requires the child key values (21000013) to exist in the parent table" I'm wondering before if I change the value of that...
4
2805
by: eBob.com | last post by:
I have a "parent" form (if that's the right terminology), Form1. I declare two public values in the parent form : Public Class Form1 Inherits System.Windows.Forms.Form Public CurDir As String = Directory.GetCurrentDirectory() 'used by FormGetJobOutput Public PubUser As String 'tbxUser.text value for subForms In the "child" form, I call it FormGetJobOutput, I reference these two public values ...
3
2403
by: PAUL | last post by:
Hello, I have 2 datasets I am trying to update. The parent table seems to update fine but when I go update the chiled table I get an error message that says I need a related record in the parent table. However I put some code in to display the key field of each parent table record (parent dataset) and the value I am trying to put into the child table is there. ParentTable ChildTable ID------------------------<...
5
3528
by: PAUL | last post by:
Hello, I have 2 tables with a relationship set up in the dataset with vb ..net. I add a new record to the parent table then edit an existing child record to have the new parent ID. However when I do the update the changed parentid in the child table fails to change. No error is given its just that the change is not written to the Database. When I step through the records for the child table the one I would expect to be changed has a row...
1
4262
by: Lyle Fairfield | last post by:
Option Explicit ' requires VBScript to be installed ' (maybe don't give this to your sugnificant other as ' it gets deleted addresses as well as current) ' obvious fixups needed '1. how get wab file location ' further development '1. get names too? ' maybe some WABs are encrypted
27
3771
by: max | last post by:
Hello, I am a newbye, and I'm trying to write a simple application. I have five tables with three columns; all tables are identical; I need to change some data in the first table and let VB updates the same data in all other four tables in the right places. I know it would be possible by using the ForeignKeyConstraint object. I have created the tables using the DataSet Visual Tool and I know it doesn't create any ForeignKeyConstraint obj....
0
7887
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8274
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8381
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8036
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8259
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6695
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5434
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2404
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1494
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.