Re: Transpose query results?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: khalprin (khalprin_at_discussions.microsoft.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 08:57:01 -0800

Thanks for your wonderful help.
I'll worry about why the data is stored as it is - that is not currently the
issue. Describing the way the data needs to be presented in the end result
provides more information to solve the problem... for those willing to help.
 

"--CELKO--" wrote:

> This design flaw is called EAV (Entity-Attribute-Value) in the
> literature. It comes from not separating data and metadata.
>
> >> This has a record for each configurable property <<
>
> Rows are not records; attributes are not properties. You are not even
> speaking in relational terms.
>
> >> I need to use the records [sic] from the 'Properties' table as the
> columns in a grid and display the values <<
>
> SQL has nothing to do with display; in a tiered architecture the front
> end does display. You are not separating the presentation layer.
>
> You might want to read at least one book on RDBMS and one on data
> modeling and start over.
>
>

Relevant Pages

  • Re: Two date pickers
    ... You shouldn't have to worry about that. ... Dates are stored as Doubles; ... is only when you display them or assign them from Strings that regional ...
    (microsoft.public.vb.general.discussion)
  • Re: Help reducing object instance size
    ... divorce the gui from the data is displays. ... confortably fix on a display at one time. ... displayed than it is for the data to worry about if it is displayed. ... and working with dynamic arrays of integer is about as space efficient as ...
    (comp.lang.pascal.delphi.misc)
  • Re: Widerscreen
    ... However, the ratio of these two figures is not 4x3, but 3.75x3, ... which means the pixels are not square when displayed on your telly - ... The output would then map onto the display with the same ... If you wish to worry about this, I'd suggest you worry more about fitting ...
    (uk.tech.digital-tv)
  • Re: Transpose query results?
    ... literature. ... It comes from not separating data and metadata. ... SQL has nothing to do with display; in a tiered architecture the front ...
    (microsoft.public.sqlserver.programming)
  • RE: Forcing date format
    ... The text box on your form has a property called Control Tip Text where you ... enter information that is display when the mouse moves over the text box. ... is there any markers I can put in access to advise how this data needs ...
    (microsoft.public.access.tablesdbdesign)