Invoking a service on firing a trigger

Hi

Im trying to invoke a .Net service when a trigger is fired on a table in SQL Server 2000.

The service is working fine but I need to invoke it when the trigger is fired. How can I achieve this?

Hi!

At first, why do you think your problem is concern with SQL-NS? The second: does you question relate to SQL Server 2005? You have wrote, that the trigger on SQL Server 2000 invokes the service and the services works well.

Then, what do you mean by saying "invokes"? Does the trigger start the service or it just send a message to him?

Invoking a service on firing a trigger

Hi

Im trying to invoke a .Net service when a trigger is fired on a table in SQL Server 2000.

The service is working fine but I need to invoke it when the trigger is fired. How can I achieve this?

Hi!

At first, why do you think your problem is concern with SQL-NS? The second: does you question relate to SQL Server 2005? You have wrote, that the trigger on SQL Server 2000 invokes the service and the services works well.

Then, what do you mean by saying "invokes"? Does the trigger start the service or it just send a message to him?

Invisible Parameters

Hi,
How do i make parameters invisible.
Scenario:
I am doing the dynamic sorting. I put 2 textboxes next to the table header
asc/desc
and am doing osrting sending values by parameters and reloading the report
with sorted options.
But how do i make them invisible parameters ?i.e, the parameters shouldnt be
shown on the report.
When i try making the prompt blank - it gives me an error that the parameter
is only read only.
Please help
Thanks
RamDid you put a Default value before making clearing the prompt text?
--
Thanks
Ravi
"Ramani" wrote:
> Hi,
> How do i make parameters invisible.
> Scenario:
> I am doing the dynamic sorting. I put 2 textboxes next to the table header
> asc/desc
> and am doing osrting sending values by parameters and reloading the report
> with sorted options.
> But how do i make them invisible parameters ?i.e, the parameters shouldnt be
> shown on the report.
> When i try making the prompt blank - it gives me an error that the parameter
> is only read only.
> Please help
> Thanks
> Ram|||Yes, I did. I set the default values.
"Ravi" wrote:
> Did you put a Default value before making clearing the prompt text?
> --
> Thanks
> Ravi
>
> "Ramani" wrote:
> > Hi,
> > How do i make parameters invisible.
> > Scenario:
> > I am doing the dynamic sorting. I put 2 textboxes next to the table header
> > asc/desc
> > and am doing osrting sending values by parameters and reloading the report
> > with sorted options.
> > But how do i make them invisible parameters ?i.e, the parameters shouldnt be
> > shown on the report.
> > When i try making the prompt blank - it gives me an error that the parameter
> > is only read only.
> > Please help
> > Thanks
> > Ram|||I solved this problem by upgrading the server to at least the service pack 1
of reporting services. Then the "readonly" error no longer appears. It is to
my knowledge the only way to get rid of that ?&%$&* message.
To make sure you have the right version of Reporting Services, go to the
base URL for the report server (typically http://servername/reportserver/. At
the bottom of the browser page will be the version number:
Microsoft SQL Server Reporting Services Version 8.00.743.00 <- this is
old
Microsoft SQL Server Reporting Services Version 8.00.878.00 <- this is
SP1
Hope this helps.
"Ramani" wrote:
> Yes, I did. I set the default values.
> "Ravi" wrote:
> > Did you put a Default value before making clearing the prompt text?
> >
> > --
> > Thanks
> > Ravi
> >
> >
> > "Ramani" wrote:
> >
> > > Hi,
> > > How do i make parameters invisible.
> > > Scenario:
> > > I am doing the dynamic sorting. I put 2 textboxes next to the table header
> > > asc/desc
> > > and am doing osrting sending values by parameters and reloading the report
> > > with sorted options.
> > > But how do i make them invisible parameters ?i.e, the parameters shouldnt be
> > > shown on the report.
> > > When i try making the prompt blank - it gives me an error that the parameter
> > > is only read only.
> > > Please help
> > > Thanks
> > > Ram|||I have sp2 installed .. will that be fine ?
"Eric" wrote:
> I solved this problem by upgrading the server to at least the service pack 1
> of reporting services. Then the "readonly" error no longer appears. It is to
> my knowledge the only way to get rid of that ?&%$&* message.
> To make sure you have the right version of Reporting Services, go to the
> base URL for the report server (typically http://servername/reportserver/. At
> the bottom of the browser page will be the version number:
> Microsoft SQL Server Reporting Services Version 8.00.743.00 <- this is
> old
> Microsoft SQL Server Reporting Services Version 8.00.878.00 <- this is
> SP1
> Hope this helps.
> "Ramani" wrote:
> > Yes, I did. I set the default values.
> >
> > "Ravi" wrote:
> >
> > > Did you put a Default value before making clearing the prompt text?
> > >
> > > --
> > > Thanks
> > > Ravi
> > >
> > >
> > > "Ramani" wrote:
> > >
> > > > Hi,
> > > > How do i make parameters invisible.
> > > > Scenario:
> > > > I am doing the dynamic sorting. I put 2 textboxes next to the table header
> > > > asc/desc
> > > > and am doing osrting sending values by parameters and reloading the report
> > > > with sorted options.
> > > > But how do i make them invisible parameters ?i.e, the parameters shouldnt be
> > > > shown on the report.
> > > > When i try making the prompt blank - it gives me an error that the parameter
> > > > is only read only.
> > > > Please help
> > > > Thanks
> > > > Ramsql

Investigating Deleted Records

I am investigating an issue where a bunch (6000) records got deleted
from a table. I am using SQL 2000 Standard and have my data recovery
model set to Full. I am using Red-Gate SQL log rescue to look at the
log and to recover the records.
My real question is: Is there a way to find out what SQL statement
created a given log entry? Is there some way to match a log entry to a
trace in the SQL Profiler?
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
3/27/2007 5:51:50 PMTransaction logging only log the effect of the commands submitted. So, any log mining tool cannot
get the actual command from the transaction log. However, you might be able to correlated the log
records with a profiler trace based on things like spid, date and time. I would assume that a log
mining tool could do this if provided with a profiler trace, but the tool would of course need to
have such feature.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Japheth Nolt" <japheth.remove@.landiscomputer.com> wrote in message
news:xn0f47mo0ktq9v001@.msnews.microsoft.com...
>I am investigating an issue where a bunch (6000) records got deleted
> from a table. I am using SQL 2000 Standard and have my data recovery
> model set to Full. I am using Red-Gate SQL log rescue to look at the
> log and to recover the records.
> My real question is: Is there a way to find out what SQL statement
> created a given log entry? Is there some way to match a log entry to a
> trace in the SQL Profiler?
> --
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 3/27/2007 5:51:50 PMsql

Investigating Deleted Records

I am investigating an issue where a bunch (6000) records got deleted
from a table. I am using SQL 2000 Standard and have my data recovery
model set to Full. I am using Red-Gate SQL log rescue to look at the
log and to recover the records.
My real question is: Is there a way to find out what SQL statement
created a given log entry? Is there some way to match a log entry to a
trace in the SQL Profiler?
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
3/27/2007 5:51:50 PMTransaction logging only log the effect of the commands submitted. So, any l
og mining tool cannot
get the actual command from the transaction log. However, you might be able
to correlated the log
records with a profiler trace based on things like spid, date and time. I wo
uld assume that a log
mining tool could do this if provided with a profiler trace, but the tool wo
uld of course need to
have such feature.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Japheth Nolt" <japheth.remove@.landiscomputer.com> wrote in message
news:xn0f47mo0ktq9v001@.msnews.microsoft.com...
>I am investigating an issue where a bunch (6000) records got deleted
> from a table. I am using SQL 2000 Standard and have my data recovery
> model set to Full. I am using Red-Gate SQL log rescue to look at the
> log and to recover the records.
> My real question is: Is there a way to find out what SQL statement
> created a given log entry? Is there some way to match a log entry to a
> trace in the SQL Profiler?
> --
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 3/27/2007 5:51:50 PM

Investigating Deleted Records

I am investigating an issue where a bunch (6000) records got deleted
from a table. I am using SQL 2000 Standard and have my data recovery
model set to Full. I am using Red-Gate SQL log rescue to look at the
log and to recover the records.
My real question is: Is there a way to find out what SQL statement
created a given log entry? Is there some way to match a log entry to a
trace in the SQL Profiler?
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
3/27/2007 5:51:50 PM
Transaction logging only log the effect of the commands submitted. So, any log mining tool cannot
get the actual command from the transaction log. However, you might be able to correlated the log
records with a profiler trace based on things like spid, date and time. I would assume that a log
mining tool could do this if provided with a profiler trace, but the tool would of course need to
have such feature.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Japheth Nolt" <japheth.remove@.landiscomputer.com> wrote in message
news:xn0f47mo0ktq9v001@.msnews.microsoft.com...
>I am investigating an issue where a bunch (6000) records got deleted
> from a table. I am using SQL 2000 Standard and have my data recovery
> model set to Full. I am using Red-Gate SQL log rescue to look at the
> log and to recover the records.
> My real question is: Is there a way to find out what SQL statement
> created a given log entry? Is there some way to match a log entry to a
> trace in the SQL Profiler?
> --
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 3/27/2007 5:51:50 PM

Invert Rows and Columns in Tables

I have many fields but only a few rows to display. How do I invert the table with Report Services Designer so that Field (Columns) go down the page and the row items go across the page?

The best way to do this is to use Matrix instead of table for more help and examples check those links

http://msdn2.microsoft.com/en-us/library/ms251712(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/ms251709(VS.80).aspx

Invert rows and columns (PIVOT)

Hi everybody.

I have this table that contains how many items were sold (and their value) into two departments:

SellerID(PK)	Year(PK)	ItemsSoldDPT1	ItemsSoldDPT2	ValueSoldDPT1	ValueSoldDPT2
1	2002	10	20	300.00	400.00
1	2003	13	71	450.00	320.00
1	2004	8	4	350.00	640.00
1	2005	2	15	110.00	680.00
2	2001	3	1	130.00	100.00
2	2005	1	7	190.00	200.00
2	2006	6	9	170.00	500.00
...	...	...	...	...	...

I'm trying to write a query that puts the data present in the "Year" column as if they were in a row (column definitions)..making sums of pieces and values.. or.. to be more clear..

I want to obtain this:

SellerID	2001 Items	2001 Values	2002 Items	2002 Values	2003 Items	2003 Values	2004 Items	2004 Values	2005 Items	2005 Values	2006 Items	2006 Values	...
1	(NULL)	(NULL)	30	700.00	84	770.00	12	990.00	17	790.00	(NULL)	(NULL)	...
2	4	230.00	(NULL)	(NULL)	(NULL)	(NULL)	(NULL)	(NULL)	8	390.00	15	670.00	...
...	...	..	...	...	...	...	...	...	...	...	...	...	...

Any ideas? I think I should use the PIVOT keyword to write the sql but I can't figure how it works and how can I do that sums.

Please note: I don't know how many distinct values of "Year" exists and the min and max year can be specified by the user.

Thank you for your help.

It is best to use the standard SQL approach of using GROUP BY and CASE expressions. Pivot can only be used to pivot one set of values. You have to write more complex query if you want to just use PIVOT operator and performance will be bad for those approaches.

select t.SellerID

, sum(case t.Year when 2001 then t.ItemsSoldDPT1 + t.ItemsSoldDPT2 end) as 2001_Values

, sum(case t.Year when 2001 then t.ValuesSoldDPT1 + t.ValuesSoldDPT2 end) as 2001_Values

, sum(case t.Year when 2002 then t.ItemsSoldDPT1 + t.ItemsSoldDPT2 end) as 2002_Values

, sum(case t.Year when 2002 then t.ValuesSoldDPT1 + t.ValuesSoldDPT2 end) as 2002_Values

...

from tbl as t

group by t.SellerID

|||Thank you for your interest and your time.
I already thought at this solution (it was the first approach I used) but this means that I must build a query that contains a couple of "sum(...) as ..." for each year I want to consider.. and I know neither how many different years are contained in the table nor how big is the date interval..
Moreover I discarted this approach because I can only replace the initial and final year value in the SQL query (something like a "tag replace"). We use a particular reporting tecnology that accepts queries at design time and replaces variables at runtime (with typed parameters).

So I have to write something like
SELECT.... xxx...xxx..xxx
WHERE...
and Year>=[%shortInitialYear] and Year<=[%shortFinalYear]

Even if I could use the PIVOT keyword I have a similar problem because the pivot keyword assumes that the user has to specify each value to pivot "IN ([value1], [value2], [value3])" and not a range (something like "BETWEEN [%shortInitialYear] and [%shortFinalYear]" )|||

hi

i understand exactly what you mean.

here is a short description on what i did to solve the problem, i apologize for not having the time to go into more detail but you'll figure this out quickly

first do a query where you would get the distinct date information with the amounts (sum it if you want), in a view would be best

then when you have got the distinct dates create a new temporary table, dynamically of course. i created the tabel and in a cursor added the columns (which was a result from the view)

then insert into your dynamic table the values into columns corresponding to the view you have created.

this whole approach works if your dynamic sql logic is sound, best is that you don't have to specify any thing other than what you want in the original view.

hope this helps

|||

It is a known annoyance :) You can use pivot by flattening out the set: http://drsql.spaces.msn.com/blog/cns!80677FB08B3162E4!758.entry but like Umachandar said, the "classic" style is easier/faster. If you want to help change this, vote here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127071

The easiest thing to do is to just make your SUM clauses dynamic:

create table year
(
year char(4) primary key
)
insert into year
select 2001
union all
select 2002
go
declare @.query varchar(8000)
select @.query = 'select t.SellerID ' + char(10) + (
SELECT distinct
', sum(case t.Year when ''' + year + ''' then t.ItemsSoldDPT1 + t.ItemsSoldDPT2 end) as ' + year + '_Values' + char(10) +
', sum(case t.Year when ''' + year + ''' then t.ValuesSoldDPT1 + t.ValuesSoldDPT2 end) as ' + year + '_Values' + char(10)
AS [text()]
FROM
year y
FOR XML PATH('') ) + char(10) + ' from tbl as t group by t.SellerID'

select @.query

I used 2005 syntax to build the sum columns, since I think you have 2005, in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=488720&SiteID=1 there is another full example.

sql

Inventory update problem

I am trying to update a master inventory table from an order details table, the query below works fine except when the order details table contains the same code number multiple times. When this occurs the update only updates for the first instance of the code number.

How do I make the update work for all the records not just the unique records?

UPDATE Inventory.Inventory
SET Qty = Inventory.Inventory.Qty - Retail.OrderDetails.Qty FROM Inventory.Inventory INNER JOIN
Retail.OrderDetails ON Inventory.Inventory.Code = Retail.OrderDetails.Code
WHERE (Retail.OrderDetails.Invoice = 207070202)

Thanks

Quote:

Originally Posted by Kliot

I am trying to update a master inventory table from an order details table, the query below works fine except when the order details table contains the same code number multiple times. When this occurs the update only updates for the first instance of the code number.

How do I make the update work for all the records not just the unique records?

UPDATE Inventory.Inventory
SET Qty = Inventory.Inventory.Qty - Retail.OrderDetails.Qty FROM Inventory.Inventory INNER JOIN
Retail.OrderDetails ON Inventory.Inventory.Code = Retail.OrderDetails.Code
WHERE (Retail.OrderDetails.Invoice = 207070202)

Thanks

I think it is not possible in SQL Server. But it will work in MS Access.

You have to fetch record and then update it|||hi

i have gone through ur query, but if possible just send me 1 or two records of each table and tell me exactily what u want|||Here is an example,

Invoice table

Code|||Here is an example,

Invoice table

Code Quantity
DM01 2
LG02 2
DM01 3
QP76 1

The update query will update the Inventory table quantity for DM01 by 2 not 5, the second DM01 is not updated

I can get around this by doing a sum query inside the select but it's not ideal.

UPDATE Inventory.Inventory
set RQty = Inventory.Inventory.RQty - od.Quantity
FROM (SELECT Code, SUM(Quantity) AS Quantity FROM Retail.OrderDetails WHERE Invoice = 207022101
GROUP BY Code) as od WHERE(Inventory.inventory.code = od.code)

invalid value for 'table' on 'relationship'

I'm using sqlxml3.0 to load a schema file. I cannot, for the life of me,
figure out why I keep getting this error message "-2147467259 Schema:
invalid value for 'table' on 'relationship'".
If anyone can offer the path to a solution it would be most appreciated.
Thanks
Schema:
Here is the schema:
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="relactionstep1" child="step1" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relactionpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reladjustproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relc_statementcrittech" child="crittech"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relc_statementreasondate" child="reasondate"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relc_statementreleaseagent" child="releaseagent"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcalibrationproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcautiontrim_para" child="trim_para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcheckstepstep1" child="step1" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcheckstepindication" child="indication"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcheckstepaction" child="action"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcleanproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcomp-itemtitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcomp-itempara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcpcdatapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldefpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldeflistterm_def" child="term_def"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwpeqpinfo" child="eqpinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwplocdesc" child="locdesc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwpeqpdata" child="eqpdata"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldestrpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldestructmatpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldistc_statement" child="c_statement"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="releicnomensysnomen" child="sysnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="releirpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdatatitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdatapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdesctitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdescpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpinfoeqpdesc" child="eqpdesc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relexportpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relfiguretitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relfiguregraphic" child="graphic"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frntloepwp" child="loepwp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frntfrntcover" child="frntcover"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frntcontents" child="contents"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frnthowtouse" child="howtouse"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_manualframed_frnt" child="framed_frnt"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_manualgim" child="gim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualtim" child="tim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualmim" child="mim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualsim" child="sim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualda2028" child="da2028"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcovertmtitle" child="tmtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcovergraphic" child="graphic"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcovernotices" child="notices"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcoverservnomen" child="servnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgen_maintwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgen_maintwpwpinfo" child="wpinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgen_maintwpproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgen_maintwpmaintsk" child="maintsk"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgeninfotitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgeninfopara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgeninfospecpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgimginfowp" child="ginfowp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgimdescwp" child="descwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpscope" child="scope" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpmfrr" child="mfrr" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpeir" child="eir" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpcpcdata" child="cpcdata"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpodsdata" child="odsdata"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpdestructmat" child="destructmat"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowppssref" child="pssref" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpwrntyref" child="wrntyref"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpnomenreflist" child="nomenreflist"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relhowtouseproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relidentnopartno" child="partno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relidentnocageno" child="cageno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relindicationstep1" child="step1"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relindicationsubtitle" child="subtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relindicationpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relinspinstitmsubtitle" child="subtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relinspinstitmpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relinspinstitmspecpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relinstallproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relinternetemail" child="email" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintrotitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintropara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintroparatitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintroparapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="rellocdesccomp-item" child="comp-item"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relloepwpnote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relloepwprev_date" child="rev_date"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relloepwppara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relloepwprev_chg" child="rev_chg"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="rellubeproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskservice" child="service"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskinspinstitm" child="inspinstitm"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskclean" child="clean" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskcaution" child="caution"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskwarning" child="warning"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskremove" child="remove" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskrepair-rplc" child="repair-rplc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintsklube" child="lube" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintsknote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskprepforuse" child="prepforuse"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskadjust" child="adjust" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskinstall" child="install"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskcalibration" child="calibration"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskservice" child="service"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskremove" child="remove" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskrepair-rplc" child="repair-rplc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpwpinfo" child="wpinfo" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintwpgeninfo" child="geninfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpwarning" child="warning"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpnote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintwpmaintsk" child="maintsk"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmfrrpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmimpmcsintrowp" child="pmcsintrowp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmimpmcswp" child="pmcswp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmimgen_maintwp" child="gen_maintwp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmimmaintwp" child="maintwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmrplpartpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relnomenreflistpara" child="para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relnotetrim_para" child="trim_para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relnoticesdist" child="dist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relnoticesexport" child="export" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relnoticesdestr" child="destr" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relodsdatapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relopcheck-tsproctitle" child="title"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tsproctestproc" child="testproc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpwpinfo" child="wpinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpintro" child="intro"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpproc" child="proc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpopcheck-tsproc"
child="opcheck-tsproc" parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparaemphasis" child="emphasis"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparainternet" child="internet"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparafigure" child="figure" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relparaxref" child="xref" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpararandlist" child="randlist"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparaseqlist" child="seqlist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relparanull" child="null" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relparadeflist" child="deflist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpersnreqpersnreq-setup-item"
child="persnreq-setup-item" parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpersnreq-setup-itemname" child="name"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcsintrowpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcsintrowpintropara" child="intropara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcswpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcswpwpinfo" child="wpinfo" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpmcswpmrplpart" child="mrplpart"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relprepforuseproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relproctitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relprocnote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relprocpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relproccaution" child="caution" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relprocstep1" child="step1" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relproductionframed_manual" child="framed_manual"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relprtitlesysnomen" child="sysnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpssrefpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpublisttitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpublistpubident" child="pubident"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpublistname" child="name" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrandlistitem" child="item" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrefref-setup-item" child="ref-setup-item"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relref-setup-itemextref" child="extref"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relrefwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relrefwpscope" child="scope" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrefwppublist" child="publist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relremovefigure" child="figure" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relremoveproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrepair-rplcproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_chgwpno" child="wpno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_chgrev_no" child="rev_no" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_datetitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_daterev_no" child="rev_no"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relrev_datedate" child="date" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relscopepara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relseqlistitem" child="item" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relservicesubtitle" child="subtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relservicespecpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relservicepara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relserviceproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsimrefwp" child="refwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relspecparawarning" child="warning"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relspecparacaution" child="caution"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relspecparanote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relspecparapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep1para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep1specpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relstep1step2" child="step2" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep2para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep2step3" child="step3" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep2specpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relstep3para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep3step4" child="step4" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep3specpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relstep4para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsysnomenname" child="name" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsysnomeneic" child="eic" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relterm_defterm" child="term" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relterm_defdef" child="def" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltesteqptesteqp-setup-item"
child="testeqp-setup-item" parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltesteqp-setup-itemname" child="name"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltesteqp-setup-itemidentno" child="identno"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltestproccheckstep" child="checkstep"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltimtsintrowp" child="tsintrowp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltimtsindxwp" child="tsindxwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltimopcheck-tswp" child="opcheck-tswp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltitlepgname" child="name" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltminfonotmno" child="tmno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltmtitletminfono" child="tminfono"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltmtitleprtitle" child="prtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltoolstools-setup-item" child="tools-setup-item"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltools-setup-itemname" child="name"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltools-setup-itemidentno" child="identno"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relts-categorytitle" child="title"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relts-categorytsindx-entry" child="tsindx-entry"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxts-category" child="ts-category"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindx-entrymalfunc" child="malfunc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindx-entryxref" child="xref"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxwpgeninfo" child="geninfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxwptsindx" child="tsindx"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsintrowpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsintrowptitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltsintrowppara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwarningtrim_para" child="trim_para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpidinfomaintlvl" child="maintlvl"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpidinfoeicnomen" child="eicnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpidinfotitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwpinfotools" child="tools" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwpinfotesteqp" child="testeqp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpinfopersnreq" child="persnreq"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpinfonull" child="null" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwpinforef" child="ref" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwrntyrefpara" child="para" parent-key="key_id"
child-key="parent_id"/>
</xs:appinfo>
</xs:annotation>
<xs:element name="action" sql:relation="action">
<xs:complexType>
<xs:choice>
<xs:element ref="step1" maxOccurs="unbounded" sql:relation="step1"
sql:relationship="relactionstep1"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relactionpara"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="adjust" sql:relation="adjust">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="reladjustproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="c_statement" sql:relation="c_statement">
<xs:complexType>
<xs:sequence>
<xs:element ref="crittech" sql:relation="crittech"
sql:relationship="relc_statementcrittech"/>
<xs:element ref="reasondate" sql:relation="reasondate"
sql:relationship="relc_statementreasondate"/>
<xs:element ref="releaseagent" sql:relation="releaseagent"
sql:relationship="relc_statementreleaseagent"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="cageno" sql:relation="cageno">
<xs:complexType/>
</xs:element>
<xs:element name="calibration" sql:relation="calibration">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relcalibrationproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="caution" sql:relation="caution">
<xs:complexType>
<xs:sequence>
<xs:element ref="trim_para" maxOccurs="unbounded" sql:relation="trim_para"
sql:relationship="relcautiontrim_para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="checkstep" sql:relation="checkstep">
<xs:complexType>
<xs:sequence>
<xs:element ref="step1" maxOccurs="unbounded" sql:relation="step1"
sql:relationship="relcheckstepstep1"/>
<xs:element ref="indication" sql:relation="indication"
sql:relationship="relcheckstepindication"/>
<xs:element ref="action" sql:relation="action"
sql:relationship="relcheckstepaction"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="clean" sql:relation="clean">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relcleanproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="comp-item" sql:relation="comp-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relcomp-itemtitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relcomp-itempara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="contents" sql:relation="contents">
<xs:complexType/>
</xs:element>
<xs:element name="cpcdata" sql:relation="cpcdata">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="relcpcdatapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="crittech" sql:relation="crittech">
<xs:complexType/>
</xs:element>
<xs:element name="da2028" sql:relation="da2028">
<xs:complexType/>
</xs:element>
<xs:element name="date" sql:relation="date" type="xs:string"/>
<xs:element name="def" sql:relation="def">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="reldefpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="deflist" sql:relation="deflist">
<xs:complexType>
<xs:sequence>
<xs:element ref="term_def" maxOccurs="unbounded" sql:relation="term_def"
sql:relationship="reldeflistterm_def"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="descwp" sql:relation="descwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="reldescwpwpidinfo"/>
<xs:element ref="eqpinfo" sql:relation="eqpinfo"
sql:relationship="reldescwpeqpinfo"/>
<xs:element ref="locdesc" sql:relation="locdesc"
sql:relationship="reldescwplocdesc"/>
<xs:element ref="eqpdata" sql:relation="eqpdata"
sql:relationship="reldescwpeqpdata"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="destr" sql:relation="destr">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="reldestrpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="destructmat" sql:relation="destructmat">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="reldestructmatpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="dist" sql:relation="dist">
<xs:complexType>
<xs:sequence>
<xs:element ref="c_statement" sql:relation="c_statement"
sql:relationship="reldistc_statement"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eic" sql:relation="eic" type="xs:string"/>
<xs:element name="eicnomen" sql:relation="eicnomen">
<xs:complexType>
<xs:sequence>
<xs:element ref="sysnomen" sql:relation="sysnomen"
sql:relationship="releicnomensysnomen"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eir" sql:relation="eir">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="releirpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="email" sql:relation="email">
<xs:complexType>
<xs:attribute name="address" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="emphasis" sql:relation="emphasis">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="emph" type="xs:string" use="required"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="eqpdata" sql:relation="eqpdata">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="releqpdatatitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="releqpdatapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eqpdesc" sql:relation="eqpdesc">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="releqpdesctitle"/>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="releqpdescpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eqpinfo" sql:relation="eqpinfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="eqpdesc" maxOccurs="unbounded" sql:relation="eqpdesc"
sql:relationship="releqpinfoeqpdesc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="export" sql:relation="export">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relexportpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="extref" sql:relation="extref">
<xs:complexType>
<xs:attribute name="docno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="figure" sql:relation="figure">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relfiguretitle"/>
<xs:element ref="graphic" sql:relation="graphic"
sql:relationship="relfiguregraphic"/>
</xs:sequence>
<xs:attribute name="label" use="required" type="xs:string"/>
<xs:attribute name="id"/>
<xs:attribute name="config" type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="framed_frnt" sql:relation="framed_frnt">
<xs:complexType>
<xs:sequence>
<xs:element ref="loepwp" sql:relation="loepwp"
sql:relationship="relframed_frntloepwp"/>
<xs:element ref="frntcover" sql:relation="frntcover"
sql:relationship="relframed_frntfrntcover"/>
<xs:element ref="contents" sql:relation="contents"
sql:relationship="relframed_frntcontents"/>
<xs:element ref="howtouse" sql:relation="howtouse"
sql:relationship="relframed_frnthowtouse"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="framed_manual" sql:relation="framed_manual">
<xs:complexType>
<xs:sequence>
<xs:element ref="framed_frnt" sql:relation="framed_frnt"
sql:relationship="relframed_manualframed_frnt"/>
<xs:element ref="gim" sql:relation="gim"
sql:relationship="relframed_manualgim"/>
<xs:element ref="tim" sql:relation="tim"
sql:relationship="relframed_manualtim"/>
<xs:element ref="mim" sql:relation="mim"
sql:relationship="relframed_manualmim"/>
<xs:element ref="sim" sql:relation="sim"
sql:relationship="relframed_manualsim"/>
<xs:element ref="da2028" sql:relation="da2028"
sql:relationship="relframed_manualda2028"/>
</xs:sequence>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="maintitl" type="xs:string" use="required"/>
<xs:attribute name="maintlvls" type="xs:string" use="required"/>
<xs:attribute name="currentasof" type="xs:string" use="required"/>
<xs:attribute name="date" type="xs:string" use="required"/>
<xs:attribute name="pubno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="frntcover" sql:relation="frntcover">
<xs:complexType>
<xs:sequence>
<xs:element ref="tmtitle" sql:relation="tmtitle"
sql:relationship="relfrntcovertmtitle"/>
<xs:element ref="graphic" sql:relation="graphic"
sql:relationship="relfrntcovergraphic"/>
<xs:element ref="notices" sql:relation="notices"
sql:relationship="relfrntcovernotices"/>
<xs:element ref="servnomen" sql:relation="servnomen"
sql:relationship="relfrntcoverservnomen"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="gen_maintwp" sql:relation="gen_maintwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relgen_maintwpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relgen_maintwpwpinfo"/>
<xs:element ref="proc" minOccurs="0" sql:relation="proc"
sql:relationship="relgen_maintwpproc"/>
<xs:element ref="maintsk" minOccurs="0" sql:relation="maintsk"
sql:relationship="relgen_maintwpmaintsk"/>
</xs:sequence>
<xs:attribute name="wpno" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="geninfo" sql:relation="geninfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relgeninfotitle"/>
<xs:element ref="para" minOccurs="0" maxOccurs="unbounded"
sql:relation="para" sql:relationship="relgeninfopara"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relgeninfospecpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="gim" sql:relation="gim">
<xs:complexType>
<xs:sequence>
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="relgimtitlepg"/>
<xs:element ref="ginfowp" sql:relation="ginfowp"
sql:relationship="relgimginfowp"/>
<xs:element ref="descwp" sql:relation="descwp"
sql:relationship="relgimdescwp"/>
</xs:sequence>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="ginfowp" sql:relation="ginfowp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relginfowpwpidinfo"/>
<xs:element ref="scope" sql:relation="scope"
sql:relationship="relginfowpscope"/>
<xs:element ref="mfrr" sql:relation="mfrr"
sql:relationship="relginfowpmfrr"/>
<xs:element ref="eir" sql:relation="eir" sql:relationship="relginfowpeir"/>
<xs:element ref="cpcdata" sql:relation="cpcdata"
sql:relationship="relginfowpcpcdata"/>
<xs:element ref="odsdata" sql:relation="odsdata"
sql:relationship="relginfowpodsdata"/>
<xs:element ref="destructmat" sql:relation="destructmat"
sql:relationship="relginfowpdestructmat"/>
<xs:element ref="pssref" sql:relation="pssref"
sql:relationship="relginfowppssref"/>
<xs:element ref="wrntyref" sql:relation="wrntyref"
sql:relationship="relginfowpwrntyref"/>
<xs:element ref="nomenreflist" sql:relation="nomenreflist"
sql:relationship="relginfowpnomenreflist"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="graphic" sql:relation="graphic">
<xs:complexType>
<xs:attribute name="boardno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="howtouse" sql:relation="howtouse">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="relhowtouseproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="identno" sql:relation="identno">
<xs:complexType>
<xs:sequence>
<xs:element ref="partno" sql:relation="partno"
sql:relationship="relidentnopartno"/>
<xs:element ref="cageno" sql:relation="cageno"
sql:relationship="relidentnocageno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="indication" sql:relation="indication">
<xs:complexType>
<xs:sequence>
<xs:element ref="step1" minOccurs="0" maxOccurs="unbounded"
sql:relation="step1" sql:relationship="relindicationstep1"/>
<xs:element ref="subtitle" minOccurs="0" sql:relation="subtitle"
sql:relationship="relindicationsubtitle"/>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relindicationpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="inspinstitm" sql:relation="inspinstitm">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="subtitle" sql:relation="subtitle"
sql:relationship="relinspinstitmsubtitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relinspinstitmpara"/>
<xs:element ref="specpara" sql:relation="specpara"
sql:relationship="relinspinstitmspecpara"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="install" sql:relation="install">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="relinstallproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="internet" sql:relation="internet">
<xs:complexType>
<xs:sequence>
<xs:element ref="email" sql:relation="email"
sql:relationship="relinternetemail"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="intro" sql:relation="intro">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="title" sql:relation="title"
sql:relationship="relintrotitle"/>
<xs:element ref="para" sql:relation="para" sql:relationship="relintropara"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="intropara" sql:relation="intropara">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relintroparatitle"/>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="relintroparapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="item" sql:relation="item" type="xs:string"/>
<xs:element name="locdesc" sql:relation="locdesc">
<xs:complexType>
<xs:sequence>
<xs:element ref="comp-item" sql:relation="comp-item"
sql:relationship="rellocdesccomp-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="loepwp" sql:relation="loepwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="note" sql:relation="note"
sql:relationship="relloepwpnote"/>
<xs:element ref="rev_date" sql:relation="rev_date"
sql:relationship="relloepwprev_date"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relloepwppara"/>
<xs:element ref="rev_chg" sql:relation="rev_chg"
sql:relationship="relloepwprev_chg"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lube" sql:relation="lube">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc" sql:relationship="rellubeproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="maintlvl" sql:relation="maintlvl">
<xs:complexType>
<xs:attribute name="level" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="maintsk" sql:relation="maintsk">
<xs:complexType>
<xs:sequence>
<xs:element ref="service" minOccurs="0" sql:relation="service"
sql:relationship="relmaintskservice"/>
<xs:element ref="inspinstitm" minOccurs="0" sql:relation="inspinstitm"
sql:relationship="relmaintskinspinstitm"/>
<xs:element ref="clean" minOccurs="0" sql:relation="clean"
sql:relationship="relmaintskclean"/>
<xs:element ref="caution" minOccurs="0" sql:relation="caution"
sql:relationship="relmaintskcaution"/>
<xs:element ref="warning" minOccurs="0" sql:relation="warning"
sql:relationship="relmaintskwarning"/>
<xs:element ref="remove" minOccurs="0" sql:relation="remove"
sql:relationship="relmaintskremove"/>
<xs:element ref="repair-rplc" minOccurs="0" sql:relation="repair-rplc"
sql:relationship="relmaintskrepair-rplc"/>
<xs:element ref="lube" minOccurs="0" sql:relation="lube"
sql:relationship="relmaintsklube"/>
<xs:element ref="note" minOccurs="0" sql:relation="note"
sql:relationship="relmaintsknote"/>
<xs:element ref="prepforuse" minOccurs="0" sql:relation="prepforuse"
sql:relationship="relmaintskprepforuse"/>
<xs:element ref="adjust" minOccurs="0" sql:relation="adjust"
sql:relationship="relmaintskadjust"/>
<xs:element ref="install" minOccurs="0" sql:relation="install"
sql:relationship="relmaintskinstall"/>
<xs:element ref="calibration" minOccurs="0" sql:relation="calibration"
sql:relationship="relmaintskcalibration"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="maintwp" sql:relation="maintwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relmaintwpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relmaintwpwpinfo"/>
<xs:element ref="geninfo" minOccurs="0" sql:relation="geninfo"
sql:relationship="relmaintwpgeninfo"/>
<xs:element ref="warning" minOccurs="0" sql:relation="warning"
sql:relationship="relmaintwpwarning"/>
<xs:element ref="note" minOccurs="0" sql:relation="note"
sql:relationship="relmaintwpnote"/>
<xs:element ref="maintsk" maxOccurs="unbounded" sql:relation="maintsk"
sql:relationship="relmaintwpmaintsk"/>
</xs:sequence>
<xs:attribute name="wpno" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="malfunc" sql:relation="malfunc">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="label" use="required">
</xs:attribute>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="mfrr" sql:relation="mfrr">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="relmfrrpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="mim" sql:relation="mim">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="relmimtitlepg"/>
<xs:element ref="pmcsintrowp" sql:relation="pmcsintrowp"
sql:relationship="relmimpmcsintrowp"/>
<xs:element ref="pmcswp" sql:relation="pmcswp"
sql:relationship="relmimpmcswp"/>
<xs:element ref="gen_maintwp" sql:relation="gen_maintwp"
sql:relationship="relmimgen_maintwp"/>
<xs:element ref="maintwp" sql:relation="maintwp"
sql:relationship="relmimmaintwp"/>
</xs:choice>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="mrplpart" sql:relation="mrplpart">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relmrplpartpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="name" sql:relation="name" type="xs:string"/>
<xs:element name="nomenreflist" sql:relation="nomenreflist">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relnomenreflistpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="note" sql:relation="note">
<xs:complexType>
<xs:sequence>
<xs:element ref="trim_para" maxOccurs="unbounded" sql:relation="trim_para"
sql:relationship="relnotetrim_para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="notices" sql:relation="notices">
<xs:complexType>
<xs:sequence>
<xs:element ref="dist" sql:relation="dist"
sql:relationship="relnoticesdist"/>
<xs:element ref="export" sql:relation="export"
sql:relationship="relnoticesexport"/>
<xs:element ref="destr" sql:relation="destr"
sql:relationship="relnoticesdestr"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="null" sql:relation="null">
<xs:complexType/>
</xs:element>
<xs:element name="odsdata" sql:relation="odsdata">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relodsdatapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="opcheck-tsproc" sql:relation="opcheck-tsproc">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" minOccurs="0" sql:relation="title"
sql:relationship="relopcheck-tsproctitle"/>
<xs:element ref="testproc" sql:relation="testproc"
sql:relationship="relopcheck-tsproctestproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="opcheck-tswp" sql:relation="opcheck-tswp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relopcheck-tswpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relopcheck-tswpwpinfo"/>
<xs:element ref="intro" minOccurs="0" sql:relation="intro"
sql:relationship="relopcheck-tswpintro"/>
<xs:element ref="proc" minOccurs="0" maxOccurs="unbounded"
sql:relation="proc" sql:relationship="relopcheck-tswpproc"/>
<xs:element ref="opcheck-tsproc" sql:relation="opcheck-tsproc"
sql:relationship="relopcheck-tswpopcheck-tsproc"/>
</xs:sequence>
<xs:attribute name="wpno" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="para" sql:relation="para">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element ref="emphasis" sql:relation="emphasis"
sql:relationship="relparaemphasis"/>
<xs:element ref="internet" sql:relation="internet"
sql:relationship="relparainternet"/>
<xs:element ref="figure" sql:relation="figure"
sql:relationship="relparafigure"/>
<xs:element ref="xref" sql:relation="xref" sql:relationship="relparaxref"/>
<xs:element ref="randlist" sql:relation="randlist"
sql:relationship="relpararandlist"/>
<xs:element ref="seqlist" sql:relation="seqlist"
sql:relationship="relparaseqlist"/>
<xs:element ref="null" sql:relation="null" sql:relationship="relparanull"/>
<xs:element ref="deflist" sql:relation="deflist"
sql:relationship="relparadeflist"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="partno" sql:relation="partno">
<xs:complexType/>
</xs:element>
<xs:element name="persnreq" sql:relation="persnreq">
<xs:complexType>
<xs:sequence>
<xs:element ref="persnreq-setup-item" sql:relation="persnreq-setup-item"
sql:relationship="relpersnreqpersnreq-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="persnreq-setup-item" sql:relation="persnreq-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="relpersnreq-setup-itemname"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="pmcsintrowp" sql:relation="pmcsintrowp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relpmcsintrowpwpidinfo"/>
<xs:element ref="intropara" maxOccurs="unbounded" sql:relation="intropara"
sql:relationship="relpmcsintrowpintropara"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="pmcswp" sql:relation="pmcswp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relpmcswpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relpmcswpwpinfo"/>
<xs:element ref="mrplpart" sql:relation="mrplpart"
sql:relationship="relpmcswpmrplpart"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="prepforuse" sql:relation="prepforuse">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relprepforuseproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="proc" sql:relation="proc">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" minOccurs="0" sql:relation="title"
sql:relationship="relproctitle"/>
<xs:element ref="note" minOccurs="0" maxOccurs="unbounded"
sql:relation="note" sql:relationship="relprocnote"/>
<xs:element ref="para" minOccurs="0" maxOccurs="unbounded"
sql:relation="para" sql:relationship="relprocpara"/>
<xs:element ref="caution" minOccurs="0" sql:relation="caution"
sql:relationship="relproccaution"/>
<xs:element ref="step1" minOccurs="0" maxOccurs="unbounded"
sql:relation="step1" sql:relationship="relprocstep1"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="production" sql:relation="production">
<xs:complexType>
<xs:sequence>
<xs:element ref="framed_manual" sql:relation="framed_manual"
sql:relationship="relproductionframed_manual"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="prtitle" sql:relation="prtitle">
<xs:complexType>
<xs:sequence>
<xs:element ref="sysnomen" sql:relation="sysnomen"
sql:relationship="relprtitlesysnomen"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="pssref" sql:relation="pssref">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relpssrefpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="pubident" sql:relation="pubident">
<xs:complexType/>
</xs:element>
<xs:element name="publist" sql:relation="publist">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relpublisttitle"/>
<xs:element ref="pubident" sql:relation="pubident"
sql:relationship="relpublistpubident"/>
<xs:element ref="name" sql:relation="name"
sql:relationship="relpublistname"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="randlist" sql:relation="randlist">
<xs:complexType>
<xs:sequence>
<xs:element ref="item" maxOccurs="unbounded" sql:relation="item"
sql:relationship="relrandlistitem"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="reasondate" sql:relation="reasondate" type="xs:string"/>
<xs:element name="ref" sql:relation="ref">
<xs:complexType>
<xs:sequence>
<xs:element ref="ref-setup-item" maxOccurs="unbounded"
sql:relation="ref-setup-item" sql:relationship="relrefref-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ref-setup-item" sql:relation="ref-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="extref" sql:relation="extref"
sql:relationship="relref-setup-itemextref"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="refwp" sql:relation="refwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relrefwpwpidinfo"/>
<xs:element ref="scope" sql:relation="scope"
sql:relationship="relrefwpscope"/>
<xs:element ref="publist" sql:relation="publist"
sql:relationship="relrefwppublist"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="releaseagent" sql:relation="releaseagent"
type="xs:string"/>
<xs:element name="remove" sql:relation="remove">
<xs:complexType>
<xs:sequence>
<xs:element ref="figure" minOccurs="0" sql:relation="figure"
sql:relationship="relremovefigure"/>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relremoveproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="repair-rplc" sql:relation="repair-rplc">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="relrepair-rplcproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="rev_chg" sql:relation="rev_chg">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpno" sql:relation="wpno"
sql:relationship="relrev_chgwpno"/>
<xs:element ref="rev_no" sql:relation="rev_no"
sql:relationship="relrev_chgrev_no"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="rev_date" sql:relation="rev_date">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relrev_datetitle"/>
<xs:element ref="rev_no" sql:relation="rev_no"
sql:relationship="relrev_daterev_no"/>
<xs:element ref="date" sql:relation="date"
sql:relationship="relrev_datedate"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="rev_no" sql:relation="rev_no">
<xs:complexType>
<xs:attribute name="no" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="scope" sql:relation="scope">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="relscopepara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="seqlist" sql:relation="seqlist">
<xs:complexType>
<xs:sequence>
<xs:element ref="item" maxOccurs="unbounded" sql:relation="item"
sql:relationship="relseqlistitem"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="service" sql:relation="service">
<xs:complexType>
<xs:sequence>
<xs:element ref="subtitle" minOccurs="0" sql:relation="subtitle"
sql:relationship="relservicesubtitle"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relservicespecpara"/>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relservicepara"/>
<xs:element ref="proc" minOccurs="0" maxOccurs="unbounded"
sql:relation="proc" sql:relationship="relserviceproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="servnomen" sql:relation="servnomen" type="xs:string"/>
<xs:element name="sim" sql:relation="sim">
<xs:complexType>
<xs:sequence>
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="relsimtitlepg"/>
<xs:element ref="refwp" sql:relation="refwp"
sql:relationship="relsimrefwp"/>
</xs:sequence>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="specpara" sql:relation="specpara">
<xs:complexType>
<xs:sequence>
<xs:element ref="warning" minOccurs="0" maxOccurs="unbounded"
sql:relation="warning" sql:relationship="relspecparawarning"/>
<xs:element ref="caution" minOccurs="0" maxOccurs="unbounded"
sql:relation="caution" sql:relationship="relspecparacaution"/>
<xs:element ref="note" minOccurs="0" maxOccurs="unbounded"
sql:relation="note" sql:relationship="relspecparanote"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relspecparapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step1" sql:relation="step1">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relstep1para"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relstep1specpara"/>
<xs:element ref="step2" minOccurs="0" maxOccurs="unbounded"
sql:relation="step2" sql:relationship="relstep1step2"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step2" sql:relation="step2">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relstep2para"/>
<xs:element ref="step3" minOccurs="0" maxOccurs="unbounded"
sql:relation="step3" sql:relationship="relstep2step3"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relstep2specpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step3" sql:relation="step3">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relstep3para"/>
<xs:element ref="step4" minOccurs="0" maxOccurs="unbounded"
sql:relation="step4" sql:relationship="relstep3step4"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relstep3specpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step4" sql:relation="step4">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="relstep4para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="subtitle" sql:relation="subtitle" type="xs:string"/>
<xs:element name="sysnomen" sql:relation="sysnomen">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="relsysnomenname"/>
<xs:element ref="eic" sql:relation="eic" sql:relationship="relsysnomeneic"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="term" sql:relation="term" type="xs:string"/>
<xs:element name="term_def" sql:relation="term_def">
<xs:complexType>
<xs:sequence>
<xs:element ref="term" sql:relation="term"
sql:relationship="relterm_defterm"/>
<xs:element ref="def" sql:relation="def" sql:relationship="relterm_defdef"/>
</xs:sequence>
<xs:attribute name="id" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="testeqp" sql:relation="testeqp">
<xs:complexType>
<xs:sequence>
<xs:element ref="testeqp-setup-item" maxOccurs="unbounded"
sql:relation="testeqp-setup-item"
sql:relationship="reltesteqptesteqp-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="testeqp-setup-item" sql:relation="testeqp-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="reltesteqp-setup-itemname"/>
<xs:element ref="identno" sql:relation="identno"
sql:relationship="reltesteqp-setup-itemidentno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="testproc" sql:relation="testproc">
<xs:complexType>
<xs:sequence>
<xs:element ref="checkstep" sql:relation="checkstep"
sql:relationship="reltestproccheckstep"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tim" sql:relation="tim">
<xs:complexType>
<xs:sequence>
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="reltimtitlepg"/>
<xs:element ref="tsintrowp" sql:relation="tsintrowp"
sql:relationship="reltimtsintrowp"/>
<xs:element ref="tsindxwp" sql:relation="tsindxwp"
sql:relationship="reltimtsindxwp"/>
<xs:element ref="opcheck-tswp" maxOccurs="unbounded"
sql:relation="opcheck-tswp" sql:relationship="reltimopcheck-tswp"/>
</xs:sequence>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="title" sql:relation="title" type="xs:string"/>
<xs:element name="titlepg" sql:relation="titlepg">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="reltitlepgname"/>
</xs:sequence>
<xs:attribute name="maintlvl" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="tminfono" sql:relation="tminfono">
<xs:complexType>
<xs:sequence>
<xs:element ref="tmno" sql:relation="tmno"
sql:relationship="reltminfonotmno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tmno" sql:relation="tmno" type="xs:string"/>
<xs:element name="tmtitle" sql:relation="tmtitle">
<xs:complexType>
<xs:sequence>
<xs:element ref="tminfono" sql:relation="tminfono"
sql:relationship="reltmtitletminfono"/>
<xs:element ref="prtitle" sql:relation="prtitle"
sql:relationship="reltmtitleprtitle"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tools" sql:relation="tools">
<xs:complexType>
<xs:sequence>
<xs:element ref="tools-setup-item" maxOccurs="unbounded"
sql:relation="tools-setup-item"
sql:relationship="reltoolstools-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tools-setup-item" sql:relation="tools-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="reltools-setup-itemname"/>
<xs:element ref="identno" sql:relation="identno"
sql:relationship="reltools-setup-itemidentno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="trim_para" sql:relation="trim_para" type="xs:string"/>
<xs:element name="ts-category" sql:relation="ts-category">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relts-categorytitle"/>
<xs:element ref="tsindx-entry" maxOccurs="unbounded"
sql:relation="tsindx-entry" sql:relationship="relts-categorytsindx-entry"/>
</xs:sequence>
<xs:attribute name="catg-name" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="tsindx" sql:relation="tsindx">
<xs:complexType>
<xs:sequence>
<xs:element ref="ts-category" sql:relation="ts-category"
sql:relationship="reltsindxts-category"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tsindx-entry" sql:relation="tsindx-entry">
<xs:complexType>
<xs:sequence>
<xs:element ref="malfunc" sql:relation="malfunc"
sql:relationship="reltsindx-entrymalfunc"/>
<xs:element ref="xref" sql:relation="xref"
sql:relationship="reltsindx-entryxref"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tsindxwp" sql:relation="tsindxwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="reltsindxwpwpidinfo"/>
<xs:element ref="geninfo" sql:relation="geninfo"
sql:relationship="reltsindxwpgeninfo"/>
<xs:element ref="tsindx" sql:relation="tsindx"
sql:relationship="reltsindxwptsindx"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="tsintrowp" sql:relation="tsintrowp">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="reltsintrowpwpidinfo"/>
<xs:element ref="title" sql:relation="title"
sql:relationship="reltsintrowptitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="reltsintrowppara"/>
</xs:choice>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="warning" sql:relation="warning">
<xs:complexType>
<xs:sequence>
<xs:element ref="trim_para" maxOccurs="unbounded" sql:relation="trim_para"
sql:relationship="relwarningtrim_para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="wpidinfo" sql:relation="wpidinfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="maintlvl" sql:relation="maintlvl"
sql:relationship="relwpidinfomaintlvl"/>
<xs:element ref="eicnomen" sql:relation="eicnomen"
sql:relationship="relwpidinfoeicnomen"/>
<xs:element ref="title" sql:relation="title"
sql:relationship="relwpidinfotitle"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="wpinfo" sql:relation="wpinfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="tools" minOccurs="0" sql:relation="tools"
sql:relationship="relwpinfotools"/>
<xs:element ref="testeqp" minOccurs="0" sql:relation="testeqp"
sql:relationship="relwpinfotesteqp"/>
<xs:element ref="persnreq" minOccurs="0" sql:relation="persnreq"
sql:relationship="relwpinfopersnreq"/>
<xs:element ref="null" minOccurs="0" sql:relation="null"
sql:relationship="relwpinfonull"/>
<xs:element ref="ref" minOccurs="0" sql:relation="ref"
sql:relationship="relwpinforef"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="wpno" sql:relation="wpno">
<xs:complexType>
<xs:attribute name="wpref" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="wrntyref" sql:relation="wrntyref">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relwrntyrefpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="xref" sql:relation="xref">
<xs:complexType>
<xs:attribute name="wpid" use="required">
</xs:attribute>
<xs:attribute name="pretext" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>
|||"Jay" <the10thREMOVECAPSletteref@.hotmail.com> wrote in message
news:O%23vCcnjTEHA.3988@.tk2msftngp13.phx.gbl...
> I'm using sqlxml3.0 to load a schema file. I cannot, for the life of me,
> figure out why I keep getting this error message "-2147467259 Schema:
> invalid value for 'table' on 'relationship'".
> If anyone can offer the path to a solution it would be most appreciated.
I would start by explicitly declaring the parent in each relationship.
Bryant
sql

Invalid Use of Null

I am getting the "Invalid use of Null" message when I execute the following code under the following conditions.

fields in SQL Server table
db_date varchar(30) --> "December 29"
db_subject varchar(200) --> "Test Subject"
db_thought text --> "This is a test to see if this works"

I execute the following code from VB6

strText = "select * from db_table where db_date = 'December 29'"
ors.open strText, dbConnect
if not ors.eof then
if not isnull(ors("db_thought")) then
txtBox1 = ors("db_thought")
end if
end if

Here is my problem. Since there is a value in db_thought the code if not isnull(ors("db_thought")) evaluates to true -- this is what I expect. However when I try to assign the ors("db_thought") to the txBox1 field I get an Invalid use of Null. What am I missing?

ThanksWhat happens if you change the if statement to:

if isnull(...) then
txtField1 = ""
else
txtField1 = ...
end if

Also, put in a msgbox before the assignment to display the value or look at it in debug mode under locals.|||Originally posted by rnealejr
What happens if you change the if statement to:

if isnull(...) then
txtField1 = ""
else
txtField1 = ...
end if

Also, put in a msgbox before the assignment to display the value or look at it in debug mode under locals.

I tired your suggestion, and I get the same results. It appears that the test to see if there is information in the field is testing to be true, but the attempt to read from the field is saying that the information is null. I have rechecked the database to see if there is valid data in the field and I see data there.