sparty1022
New member
- Joined
- Jun 7, 2005
- Messages
- 1
- Programming Experience
- 3-5
I need to write an xml file based on the results of queries to an oracle view. I am using datasets and nesting the tables. This seemed to work until I needed to nest a table within another table.
With ds.Tables("Premises")
.Columns("stateacctrecordid").ColumnMapping = MappingType.Element
.Columns("premisesdescription").ColumnMapping = MappingType.Element
.Columns("operationtype").ColumnMapping = MappingType.Element
.Columns("species").ColumnMapping = MappingType.Element
.Columns("conum").ColumnMapping = MappingType.Hidden
.Columns("active").ColumnMapping = MappingType.Hidden
End With
With ds.Tables("PremisesAddress")
.Columns("prem_id").ColumnMapping = MappingType.Hidden
.Columns("street").ColumnMapping = MappingType.Element
.Columns("city").ColumnMapping = MappingType.Element
.Columns("state").ColumnMapping = MappingType.Element
.Columns("zip").ColumnMapping = MappingType.Element
.Columns("county").ColumnMapping = MappingType.Element
.Columns("conum").ColumnMapping = MappingType.Hidden
.Columns("active").ColumnMapping = MappingType.Hidden
End With
The Premises address is supposed to nest under the premises ("stateacctrecordid"). I don't know how to get this to happen.
Is there another way I can accomplish this?
If I have an existing schema can I utilize this and re-create my oracle view?
With ds.Tables("Premises")
.Columns("stateacctrecordid").ColumnMapping = MappingType.Element
.Columns("premisesdescription").ColumnMapping = MappingType.Element
.Columns("operationtype").ColumnMapping = MappingType.Element
.Columns("species").ColumnMapping = MappingType.Element
.Columns("conum").ColumnMapping = MappingType.Hidden
.Columns("active").ColumnMapping = MappingType.Hidden
End With
With ds.Tables("PremisesAddress")
.Columns("prem_id").ColumnMapping = MappingType.Hidden
.Columns("street").ColumnMapping = MappingType.Element
.Columns("city").ColumnMapping = MappingType.Element
.Columns("state").ColumnMapping = MappingType.Element
.Columns("zip").ColumnMapping = MappingType.Element
.Columns("county").ColumnMapping = MappingType.Element
.Columns("conum").ColumnMapping = MappingType.Hidden
.Columns("active").ColumnMapping = MappingType.Hidden
End With
The Premises address is supposed to nest under the premises ("stateacctrecordid"). I don't know how to get this to happen.
Is there another way I can accomplish this?
If I have an existing schema can I utilize this and re-create my oracle view?