100分求解一个难题!!!在线等!

sonyge 2004-03-31 03:55:36
先下载 http://www.obton.com/u8.xml 我想用VC++读出每个ViewSQL(一共有三个)
以及每个ViewCols(一共有三个)里面的详细数据。我不会读,希望能给点提示。
...全文
28 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
sonyge 2004-03-31
  • 打赏
  • 举报
回复
我简化一下

<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by dfjkddddddddddddddddd (oplderffffffggfhfdhdfafsddSD) -->
<SimpleView>
<DataViews>
<ViewSQL><![CDATA[SELECT * FROM UA_ACCOUNT,ACCINFORMATION WHERE ACCINFORMATION.CNAME='ISystemID' AND cstr(trim(ACCINFORMATION.CVALUE))=cstr(trim(ISYSID))]]></ViewSQL>
<ViewCols>
<ColName Name="cAcc_Id"/>
<ColName Name="cAcc_Master"/>
<ColName Name="cAcc_Name"/>
<ColName Name="cValue"/>
</ViewCols>
</DataViews>
<DataViews>
<ViewSQL><![CDATA[SELECT IYEAR & FORMAT(IMONTH,'0#') AS QYNDQJ FROM UA_ACCOUNT,ACCINFORMATION WHERE ACCINFORMATION.CNAME='ISystemID' AND cstr(trim(ACCINFORMATION.CVALUE))=cstr(trim(ISYSID))]]></ViewSQL>
<ViewCols>
<ColName Name="QYNDQJ"/>
</ViewCols>
</DataViews>
<DataViews>
<ViewSQL><![CDATA[(select AccInformation.bEnable as AccInformation_bEnable,AccInformation.bVisible as AccInformation_bVisible,AccInformation.cCaption as AccInformation_cCaption,AccInformation.cDefault as AccInformation_cDefault,AccInformation.cID as AccInformation_cID,AccInformation.cName as AccInformation_cName,AccInformation.cSysID as AccInformation_cSysID,AccInformation.cType as AccInformation_cType,AccInformation.cValue as AccInformation_cValue from AccInformation where AccInformation.cName='cGradeLevel')]]></ViewSQL>
<ViewCols>
<ColName Name="AccInformation_bEnable"/>
<ColName Name="AccInformation_bVisible"/>
<ColName Name="AccInformation_cCaption"/>
</ViewCols>
</DataViews>
</SimpleView>
code8238 2004-03-31
  • 打赏
  • 举报
回复
简单的文件读取问题吧?
快乐鹦鹉 2004-03-31
  • 打赏
  • 举报
回复
太恐怖了。看不懂
sonyge 2004-03-31
  • 打赏
  • 举报
回复
我还是贴到这里把!!!

<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by dfjkddddddddddddddddd (oplderffffffggfhfdhdfafsddSD) -->
<SimpleView>
<DataViews Name="BU" Attribute="1" Cols="31">
<ViewDesign>
<IncludeTable>
<IT MainTable="AccInformation`AccInformation`cID" SubTable="UA_Account`UA_Account`cAcc_Id" Append="1"/>
</IncludeTable>
<Conditions>
<Condition TableName="AccInformation">
<ConditionStr><![CDATA[AccInformation.cName='ISystemID']]></ConditionStr>
</Condition>
</Conditions>
<ColNameMap>
<ColMap ShowName="AccInformation" MapTable="AccInformation" RootNumber="1" IsRoot="1" IsGroup="0">
<MapField RealField="bEnable" FieldAs="AccInformation_bEnable" GroupType="0"/>
<MapField RealField="bVisible" FieldAs="AccInformation_bVisible" GroupType="0"/>
<MapField RealField="cCaption" FieldAs="AccInformation_cCaption" GroupType="0"/>
<MapField RealField="cDefault" FieldAs="AccInformation_cDefault" GroupType="0"/>
<MapField RealField="cID" FieldAs="AccInformation_cID" GroupType="0"/>
<MapField RealField="cName" FieldAs="AccInformation_cName" GroupType="0"/>
<MapField RealField="cSysID" FieldAs="AccInformation_cSysID" GroupType="0"/>
<MapField RealField="cType" FieldAs="AccInformation_cType" GroupType="0"/>
<MapField RealField="cValue" FieldAs="AccInformation_cValue" GroupType="0"/>
</ColMap>
<ColMap ShowName="UA_Account" MapTable="UA_Account" RootNumber="1" IsRoot="0" IsGroup="0">
<MapField RealField="cAcc_Id" FieldAs="UA_Account_cAcc_Id" GroupType="0"/>
<MapField RealField="cAcc_Master" FieldAs="UA_Account_cAcc_Master" GroupType="0"/>
<MapField RealField="cAcc_Name" FieldAs="UA_Account_cAcc_Name" GroupType="0"/>
<MapField RealField="cAcc_Path" FieldAs="UA_Account_cAcc_Path" GroupType="0"/>
<MapField RealField="cCurCode" FieldAs="UA_Account_cCurCode" GroupType="0"/>
<MapField RealField="cCurName" FieldAs="UA_Account_cCurName" GroupType="0"/>
<MapField RealField="cEntType" FieldAs="UA_Account_cEntType" GroupType="0"/>
<MapField RealField="cFinKind" FieldAs="UA_Account_cFinKind" GroupType="0"/>
<MapField RealField="cFinType" FieldAs="UA_Account_cFinType" GroupType="0"/>
<MapField RealField="cTradeKind" FieldAs="UA_Account_cTradeKind" GroupType="0"/>
<MapField RealField="cUnitAbbre" FieldAs="UA_Account_cUnitAbbre" GroupType="0"/>
<MapField RealField="cUnitAddr" FieldAs="UA_Account_cUnitAddr" GroupType="0"/>
<MapField RealField="cUnitEMail" FieldAs="UA_Account_cUnitEMail" GroupType="0"/>
<MapField RealField="cUnitFax" FieldAs="UA_Account_cUnitFax" GroupType="0"/>
<MapField RealField="cUnitLP" FieldAs="UA_Account_cUnitLP" GroupType="0"/>
<MapField RealField="cUnitName" FieldAs="UA_Account_cUnitName" GroupType="0"/>
<MapField RealField="cUnitTaxNo" FieldAs="UA_Account_cUnitTaxNo" GroupType="0"/>
<MapField RealField="cUnitTel" FieldAs="UA_Account_cUnitTel" GroupType="0"/>
<MapField RealField="cUnitZap" FieldAs="UA_Account_cUnitZap" GroupType="0"/>
<MapField RealField="iMonth" FieldAs="UA_Account_iMonth" GroupType="0"/>
<MapField RealField="iSysID" FieldAs="UA_Account_iSysID" GroupType="0"/>
<MapField RealField="iYear" FieldAs="UA_Account_iYear" GroupType="0"/>
</ColMap>
</ColNameMap>
</ViewDesign>
<ViewSQL><![CDATA[SELECT * FROM UA_ACCOUNT,ACCINFORMATION WHERE ACCINFORMATION.CNAME='ISystemID' AND cstr(trim(ACCINFORMATION.CVALUE))=cstr(trim(ISYSID))]]></ViewSQL>
<ViewCols>
<ColName Name="cAcc_Id"/>
<ColName Name="cAcc_Master"/>
<ColName Name="cAcc_Name"/>
<ColName Name="cValue"/>
</ViewCols>
</DataViews>
<DataViews Name="BY" Attribute="1" Cols="1">
<ViewDesign>
<IncludeTable/>
<Conditions>
<Condition TableName="AccInformation">
<ConditionStr><![CDATA[AccInformation.cName= 'dGLStartDate']]></ConditionStr>
</Condition>
</Conditions>
<ColNameMap>
<ColMap ShowName="AccInformation" MapTable="AccInformation" RootNumber="1" IsRoot="1" IsGroup="0">
<MapField RealField="bEnable" FieldAs="AccInformation_bEnable" GroupType="0"/>
<MapField RealField="bVisible" FieldAs="AccInformation_bVisible" GroupType="0"/>
<MapField RealField="cCaption" FieldAs="AccInformation_cCaption" GroupType="0"/>
<MapField RealField="cDefault" FieldAs="AccInformation_cDefault" GroupType="0"/>
<MapField RealField="cID" FieldAs="AccInformation_cID" GroupType="0"/>
<MapField RealField="cName" FieldAs="AccInformation_cName" GroupType="0"/>
<MapField RealField="cSysID" FieldAs="AccInformation_cSysID" GroupType="0"/>
<MapField RealField="cType" FieldAs="AccInformation_cType" GroupType="0"/>
<MapField RealField="cValue" FieldAs="AccInformation_cValue" GroupType="0"/>
</ColMap>
</ColNameMap>
</ViewDesign>
<ViewSQL><![CDATA[SELECT IYEAR & FORMAT(IMONTH,'0#') AS QYNDQJ FROM UA_ACCOUNT,ACCINFORMATION WHERE ACCINFORMATION.CNAME='ISystemID' AND cstr(trim(ACCINFORMATION.CVALUE))=cstr(trim(ISYSID))]]></ViewSQL>
<ViewCols>
<ColName Name="QYNDQJ"/>
</ViewCols>
</DataViews>
<DataViews Name="BA" Attribute="2" Cols="9">
<ViewDesign>
<IncludeTable/>
<Conditions>
<Condition TableName="AccInformation">
<ConditionStr><![CDATA[AccInformation.cName='cGradeLevel']]></ConditionStr>
</Condition>
</Conditions>
<ColNameMap>
<ColMap ShowName="AccInformation" MapTable="AccInformation" RootNumber="1" IsRoot="1" IsGroup="0">
<MapField RealField="bEnable" FieldAs="AccInformation_bEnable" GroupType="0"/>
<MapField RealField="bVisible" FieldAs="AccInformation_bVisible" GroupType="0"/>
<MapField RealField="cCaption" FieldAs="AccInformation_cCaption" GroupType="0"/>
<MapField RealField="cDefault" FieldAs="AccInformation_cDefault" GroupType="0"/>
<MapField RealField="cID" FieldAs="AccInformation_cID" GroupType="0"/>
<MapField RealField="cName" FieldAs="AccInformation_cName" GroupType="0"/>
<MapField RealField="cSysID" FieldAs="AccInformation_cSysID" GroupType="0"/>
<MapField RealField="cType" FieldAs="AccInformation_cType" GroupType="0"/>
<MapField RealField="cValue" FieldAs="AccInformation_cValue" GroupType="0"/>
</ColMap>
</ColNameMap>
</ViewDesign>
<ViewSQL><![CDATA[(select AccInformation.bEnable as AccInformation_bEnable,AccInformation.bVisible as AccInformation_bVisible,AccInformation.cCaption as AccInformation_cCaption,AccInformation.cDefault as AccInformation_cDefault,AccInformation.cID as AccInformation_cID,AccInformation.cName as AccInformation_cName,AccInformation.cSysID as AccInformation_cSysID,AccInformation.cType as AccInformation_cType,AccInformation.cValue as AccInformation_cValue from AccInformation where AccInformation.cName='cGradeLevel')]]></ViewSQL>
<ViewCols>
<ColName Name="AccInformation_bEnable"/>
<ColName Name="AccInformation_bVisible"/>
<ColName Name="AccInformation_cCaption"/>
</ViewCols>
</DataViews>
</SimpleView>

3,055

社区成员

发帖
与我相关
我的任务
社区描述
VC/MFC HTML/XML
社区管理员
  • HTML/XML社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧