StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10693545
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-05-21T22:34:11.010
FavoriteCount
0
LastActivityDate
2016-01-15T03:52:17.137
LastEditDate
2017-05-23T11:53:20.327
LastEditorUserId
-1
OwnerUserId
12597
ParentId
6870485
PostTypeId
2
Score
14
ViewCount
0
LastEditorDisplayName
text
Body
First we start with what a dialog unit is. For that i'll quote one of <a href="https://stackoverflow.com/questions/395195/wpf-how-to-specify-units-in-dialog-units">my own un-answered questions</a>: <blockquote> <h2>What's a dialog unit?</h2> A dialog is a unit of measure based on the user's preferred font size. A dialog unit is defined such that the average character is 4 dialog units wide by 8 dialog units high: <img src="https://i.stack.imgur.com/yRvvQ.png" alt="enter image description here"> This means that dialog units: <ul> <li>change with selected font</li> <li>changed with selected DPI setting</li> <li>are not square</li> </ul> </blockquote> i'll also quote another of <a href="https://stackoverflow.com/questions/7147716/how-to-specify-units-in-dialog-units-in-wpf">my own un-answered questions</a>: <blockquote> You can check the <a href="https://i.stack.imgur.com/oq4uQ.png" rel="nofollow noreferrer">Windows UX Guidelines</a> to see where these measurements come from. The short version is: <ul> <li>dlu = dialog unit</li> <li>dlu is based on the font size (items change with user's font size)</li> <li>a horizontal dlu is different from a vertical dlu (dlu's are not square)</li> </ul> This comes from the definition of a dialog unit: the average character is 8dlus high by 4dlus wide. Georgia 14pt: <img src="https://i.stack.imgur.com/oq4uQ.png" alt="enter image description here"> If you use a smaller font (i.e. 8pt Tahoma verses 14pt Georgia), the dlus get smaller: Segoe UI 9pt: <img src="https://i.stack.imgur.com/LR7DR.png" alt="enter image description here"> Note: You'll notice that resolution (i.e. dpi) has no impact on the discussion. </blockquote> So what you need is the average size of a character. Microsoft has an <a href="http://support.microsoft.com/kb/145994" rel="nofollow noreferrer">official technique</a> for calculating the average character size. <ul> <li>average height: <pre><code>GetTextMetrics(dc, {var}textMetrics); averageHeight := textMetrics.tmHeight; </code></pre></li> <li>average width: Measure the string ABCDEFGHIJLKMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz using <a href="http://msdn.microsoft.com/en-us/library/dd144938%28v=vs.85%29.aspx" rel="nofollow noreferrer"><code>GetTextExtentPoint32</code></a>, and divide by 52: <pre><code>GetTextExtentPoint32(dc, PChar('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'), 52, Size)); averageWidth := size.cx / 52.0; </code></pre></li> </ul> So now you need the the size of a horizontal and a vertical dialog units. Remember that a horizontal dialog unit is 1/4 the average character width, and a vertical dlu is 1/8 the average character height: <pre><code>procedure GetDlus(dc: HDC; out HorizontalDluSize, VerticalDluSize: Real); var tm: TTextMetric; size: TSize; begin GetTextMetric(dc, tm); VerticalDluSize := tm.tmHeight / 8.0; GetTextExtentPoint32(dc, PChar('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'), 52, size); HorizontalDluSize := size.cx / 52.0; end; </code></pre> <blockquote> Note: Any code is released into the public domain. No attribution required. </blockquote>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to convert DLU into pixels?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USIan Boyd
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
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COVery detailed and interesting answer, thank you!
 singulars
 PostPostId
 PO
 UserUserId
 USAndrew

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.