HELP ME:XML中的数据显示问题!
提示信息:
- <ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="架构: Order 上丢失的属性定义 (OrderID)"?>
</ROOT>
其他设置均无误,错误在程序中,请大家指教,谢谢!
mytemplate.xml
===================================
<ROOTxmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:xpath-querymapping-schema="SampleSchema1.xml">
/Employee
</sql:xpath-query>
</ROOT>
SampleSchema1.xml
=======================================
<?xml version="1.0"?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:datatypes"
xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<ElementType name="Customer" sql:relation="Customers">
<AttributeType name="CustomerID" dt:type="id"/>
<AttributeType name="CompanyName"/>
<AttributeType name="ContactName"/>
<AttributeType name="City"/>
<AttributeType name="Fax"/>
<AttributeType name="Orders" dt:type="idrefs" sql:id-prefix="Ord-"/>
<attribute type="CustomerID"/>
<attribute type="CompanyName"/>
<attribute type="ContactName"/>
<attribute type="City"/>
<attribute type="Fax"/>
<attribute type="Orders" sql:relation="Orders" sql:field="OrderID">
<sql:relationship
key-relation="Customers"
key="CustomerID"
foreign-relation="Orders"
foreign-key="CustomerID"/>
</attribute>
<element type="Order">
<sql:relationship
key-relation="Customers"
key="CustomerID"
foreign-relation="Orders"
foreign-key="CustomerID"/>
</element>
</ElementType>
<ElementType name="Order" sql:relation="Orders">
<Attribute Typename="OrderID" dt:type="id" sql:id-prefix="Ord-"/>
<Attribute Typename="EmployeeID"/>
<Attribute Typename="OrderDate"/>
<Attribute Typename="RequiredDate"/>
<Attribute Typename="ShippedDate"/>
<attribute type="OrderID"/>
<attribute type="EmployeeID"/>
<attribute type="OrderDate"/>
<attribute type="RequiredDate"/>
<attribute type="ShippedDate"/>
<element type="OrderDetail">
<sql:relationship
key-relation="Orders"
key="OrderID"
foreign-relation="[OrderDetails]"
foreign-key="OrderID"/>
</element>
</ElementType>
<ElementType name="OrderDetail" sql:relation="[OrderDetails]"
sql:key-fields="OrderIDProductID">
<AttributeType name="ProductID" dt:type="idref"
sql:id-prefix="Prod-"/>
<AttributeType name="UnitPrice"/>
<AttributeType name="Quantity"/>
<attribute type="ProductID"/>
<attribute type="UnitPrice" sql:field="UnitPrice"/>
<attribute type="Quantity"/>
<element type="Discount" sql:field="Discount"/>
</ElementType>
<ElementType name="Discount" dt:type="string"
sql:relation="[OrderDetails]"/>
<ElementType name="Employee" sql:relation="Employees">
<Attribute Typename="EmployeeID"/>
<Attribute Typename="LastName"/>
<Attribute Typename="FirstName"/>
<Attribute Typename="Title"/>
<attribute type="EmployeeID"/>
<attribute type="LastName"/>
<attribute type="FirstName"/>
<attribute type="Title"/>
</ElementType>
</Schema>
- <ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="架构: Order 上丢失的属性定义 (OrderID)"?>
</ROOT>
其他设置均无误,错误在程序中,请大家指教,谢谢!
mytemplate.xml
===================================
<ROOTxmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:xpath-querymapping-schema="SampleSchema1.xml">
/Employee
</sql:xpath-query>
</ROOT>
SampleSchema1.xml
=======================================
<?xml version="1.0"?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:datatypes"
xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<ElementType name="Customer" sql:relation="Customers">
<AttributeType name="CustomerID" dt:type="id"/>
<AttributeType name="CompanyName"/>
<AttributeType name="ContactName"/>
<AttributeType name="City"/>
<AttributeType name="Fax"/>
<AttributeType name="Orders" dt:type="idrefs" sql:id-prefix="Ord-"/>
<attribute type="CustomerID"/>
<attribute type="CompanyName"/>
<attribute type="ContactName"/>
<attribute type="City"/>
<attribute type="Fax"/>
<attribute type="Orders" sql:relation="Orders" sql:field="OrderID">
<sql:relationship
key-relation="Customers"
key="CustomerID"
foreign-relation="Orders"
foreign-key="CustomerID"/>
</attribute>
<element type="Order">
<sql:relationship
key-relation="Customers"
key="CustomerID"
foreign-relation="Orders"
foreign-key="CustomerID"/>
</element>
</ElementType>
<ElementType name="Order" sql:relation="Orders">
<Attribute Typename="OrderID" dt:type="id" sql:id-prefix="Ord-"/>
<Attribute Typename="EmployeeID"/>
<Attribute Typename="OrderDate"/>
<Attribute Typename="RequiredDate"/>
<Attribute Typename="ShippedDate"/>
<attribute type="OrderID"/>
<attribute type="EmployeeID"/>
<attribute type="OrderDate"/>
<attribute type="RequiredDate"/>
<attribute type="ShippedDate"/>
<element type="OrderDetail">
<sql:relationship
key-relation="Orders"
key="OrderID"
foreign-relation="[OrderDetails]"
foreign-key="OrderID"/>
</element>
</ElementType>
<ElementType name="OrderDetail" sql:relation="[OrderDetails]"
sql:key-fields="OrderIDProductID">
<AttributeType name="ProductID" dt:type="idref"
sql:id-prefix="Prod-"/>
<AttributeType name="UnitPrice"/>
<AttributeType name="Quantity"/>
<attribute type="ProductID"/>
<attribute type="UnitPrice" sql:field="UnitPrice"/>
<attribute type="Quantity"/>
<element type="Discount" sql:field="Discount"/>
</ElementType>
<ElementType name="Discount" dt:type="string"
sql:relation="[OrderDetails]"/>
<ElementType name="Employee" sql:relation="Employees">
<Attribute Typename="EmployeeID"/>
<Attribute Typename="LastName"/>
<Attribute Typename="FirstName"/>
<Attribute Typename="Title"/>
<attribute type="EmployeeID"/>
<attribute type="LastName"/>
<attribute type="FirstName"/>
<attribute type="Title"/>
</ElementType>
</Schema>
...全文
相关推荐
二维码识别源码
二维码识别源码
【Redis数据库 第2章】redis中的通用命令语法介绍使用
文章对你有所帮助的话,欢迎给个赞或者 star,你的支持是对作者最大的鼓励,不足之处可以在评论区多多指正,交流学习。redis服务器上一共有16个数据库db0,db1,…例子: del name1 name2。例子:expire time 25。例子: exists name。例子: ttl name。 -2:代表键已经死亡。 -1:代表键永久存在。例子:help keys。例子: type name。例子: keys n*
qt-help学习之路(1)QT与C++ 笔记
内存泄漏 所以,我们还是推荐在栈上创建组件。因为要靠人工管理 new 和 delete 的出错概率要远大于在栈上的自动控制。除此之外,在堆上和在栈上创建已经没有任何区别。 如果你必须在堆上创建对象,不妨增加一句: label->setAttribute(Qt::WA_DeleteOnClose); 在构造函数中增加 setAttribute(Qt::WA_DeleteOnClose),在关闭时,main不会自动销毁窗口, setAttribute(Qt::WA_DeleteOnClose)会销毁一次
二维码 生成 源码 二维码 生成 源码
二维码 源码 二维码 源码二维码 源码二维码 源码二维码 源码二维码 源码二维码 源码二维码 源码二维码 源码
二维码在线生成网页源码
二维码在线生成网页源码经测试可用,非常不多的源代码。


