StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2157310
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-01-28T19:25:33.067
FavoriteCount
0
LastActivityDate
2012-03-31T12:12:48.587
LastEditDate
2012-03-31T12:12:48.587
LastEditorUserId
744588
OwnerUserId
240143
ParentId
492198
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
I am a total newbie in Delphi, but had to deal with parsing a TClientDataSet in XML format. I also needed a list of all the possible values for the field type. Did some digging into the Delphi source and came up with this list. If you want to include the field types in the schema then you should include all the types listed here: <pre><code><xs:enumeration value="string" /> <xs:enumeration value="id" /> <xs:enumeration value="idref" /> <xs:enumeration value="idrefs" /> <xs:enumeration value="entity" /> <xs:enumeration value="entities" /> <xs:enumeration value="nmtoken" /> <xs:enumeration value="nmtokens" /> <xs:enumeration value="number" /> <xs:enumeration value="int" /> <xs:enumeration value="enumeration" /> <xs:enumeration value="notation" /> <xs:enumeration value="fixed" /> <xs:enumeration value="boolean" /> <xs:enumeration value="dateTime" /> <xs:enumeration value="dateTime.tz" /> <xs:enumeration value="date" /> <xs:enumeration value="time" /> <xs:enumeration value="time.tz" /> <xs:enumeration value="i1" /> <xs:enumeration value="byte" /> <xs:enumeration value="i2" /> <xs:enumeration value="i4" /> <xs:enumeration value="i8" /> <xs:enumeration value="ui1" /> <xs:enumeration value="ui2" /> <xs:enumeration value="ui4" /> <xs:enumeration value="ui8" /> <xs:enumeration value="r4" /> <xs:enumeration value="r8" /> <xs:enumeration value="float" /> <xs:enumeration value="char" /> <xs:enumeration value="uuid" /> <xs:enumeration value="bin.hex" /> <xs:enumeration value="bin.base64" /> </code></pre> Thanks for a doing a nice job of defining this schema. This helps a lot.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAnyone that has a partial XSD that describes the METADATA section of Delphi TClientDataSet XML files?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USmenjaraz
UserOwnerUserId
1. USats
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThanks! The project I needed it for has been completed with partial validation, but when I need completer validation, I'll take your addition in to account.
 singulars
 PostPostId
 PO
 UserUserId
 USJeroen Wiert Pluimers
2. COActually, you got those from the unit `XDRSchema`, which does not define the ClientDataSet XML. That is done by the files `dsconst.h`, `dspickle.h`, and `dsxml.h`, which I used to update my answer.
 singulars
 PostPostId
 PO
 UserUserId
 USJeroen Wiert Pluimers

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.