XML Integration with ADO and Internet Explorer 5 - ADO Recordset Schema
(Page 3 of 8 )
Since we have namespaces to define the unique properties in the schema and recordset, let us examine a schema itself for the Employee table.
<s:Schema id = “RowsetSchema”>
<s:ElementType name = “row” content = “eltonly”>
<s:AttributeType name = “emp_id” rs:number= “1” rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “12” rs:maybenull = “false” />
</s:AttributeType>
<s:AttributeType name = “emp_lname” rs:number= “2” rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “40” rs:maybenull = “false” />
</s:AttributeType>
<s:AttributeType name = “emp_fname” rs:number= “3” rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “25” rs:maybenull = “false” />
</s:AttributeType>
<s:AttributeType name = “address” rs:number= “4” rs:maybenull = “true”
rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “45” />
</s:AttributeType>
<s:AttributeType name = “city” rs:number= “5” rs:maybenull = “true”
rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “20” />
</s:AttributeType>
<s:AttributeType name = “state” rs:number= “6” rs:maybenull = “true”
rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “2” rs:fixedLength= “true />
</s:AttributeType>
<s:AttributeType name = “zip” rs:number= “7” rs:maybenull = “true”
rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “5” rs:fixedLength= “true />
</s:AttributeType>
<s:AttributeType name = “phone” rs:number= “8” rs:writeunknown = “true”>
<s:datatype dt:type= “string” dt:maxLength = “12” rs:fixedLength= “true
rs:maybenull = “true” />
</s:AttributeType>
<s:AttributeType name = “contract” rs:number= “9” rs:writeunknown = “true”>
<s:datatype dt:type= “boolean” dt:maxLength = “2” rs:fixedLength= “true
rs:maybenull = “false” />
</s:AttributeType>
In order to get a good understanding of the basic concepts, we need to look at what various pieces of the document do.
Next: The Row Element >>
More XML Articles
More By Gayathri Gokul
/ 18 
