Re: Need help on a dictionary table...

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

From: Rich Millman (rmillman_at_askallied.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 12:24:18 -0500

Your post is in the wrong forum. You might want to try
microsoft.public.sqlserver.mseq or ...sqlserver.server

"Claude Vernier" <ClaudeVernier@discussions.microsoft.com> wrote in message
news:819D39C9-F16B-4319-AE77-F81881F1F84C@microsoft.com...
>
> Hi,
>
> I want to create a dictionary. For me, this a table that would contain any
> string
> I need to show in several languages and I can't find the best way to
> create
> my
> tables and the relations I should use... I need help.
>
> Here's what I have:
>
> Table: Queries
> Column: ID, int, 4
> Column: Text, varchar, 50
> Column: DictionaryID_Name, int, 4
> Sample:
> ---------------------------------------------
> | ID | Text | DictionaryID_Name |
> ---------------------------------------------
> | 1 | [xml] | 1 |
> | 2 | [xml] | 2 |
> ---------------------------------------------
>
> Table: Formattings
> Column: ID, int, 4
> Column: Text, varchar, 50
> Column: DictionaryID_Name, int, 4
> Sample:
> ---------------------------------------------
> | ID | Text | DictionaryID_Name |
> ---------------------------------------------
> | 1 | [xml] | 3 |
> | 2 | [xml] | 4 |
> ---------------------------------------------
>
>
> Table: Languages
> Column: ID, int, 4
> Column: Text, varchar, 50
> Sample:
> ---------------------
> | ID | Text |
> ---------------------
> | 1 | English |
> | 2 | French |
> ---------------------
>
> Table: Dictionary
> Column: ID, int, 4
> Column: Text, varchar, 50
> Column: LanguagesID_Name, int, 4
> Sample:
> ---------------------------------------------
> | ID | Text | LanguagesID_Name |
> ---------------------------------------------
> | 1 | Txt for Q1 | 1 |
> | 1 | Txt for Q1 | 2 |
> | 2 | Txt for Q2 | 1 |
> | 2 | Txt for Q2 | 2 |
> | 3 | Txt for F1 | 1 |
> | 3 | Txt for F1 | 2 |
> | 4 | Txt for F2 | 1 |
> | 4 | Txt for F2 | 2 |
> ---------------------------------------------
>
>
> As you can see, Dictionary would contain a version of each string for
> each supported language in Languages. The problem is, I can't make a
> relation
> between (Queries or Formattings) and Dictionary.
>
> I don't know if this is a typical problem, but I just realized my
> implementation does not work.
> If someone could help with any suggestion on this type of database...
> thanks
> you very much.
>

Relevant Pages

  • Need help on a dictionary table...
    ... I need to show in several languages and I can't find the best way to create ... Column: Text, varchar, 50 ... Column: DictionaryID_Name, int, 4 ... Dictionary would contain a version of each string for ...
    (microsoft.public.sqlserver.olap)
  • How to create a dictionary using relations ?
    ... I need to show in several languages and I can't find the best way to create ... Column: Text, varchar, 50 ... Column: DictionaryID_Name, int, 4 ... If someone could help with any suggestion on this type of database... ...
    (microsoft.public.sqlserver.mseq)
  • Re: The Advantage of Macros
    ... which is usually a single source file, can consist of external declarations ... void fx(int *x, int *y) { ... Also, if you think C is complicated, just take a look at languages like C++, ... C pushes to wrong programming styles. ...
    (alt.lang.asm)
  • Re: Interview with Mr Stroustrup
    ... extern int enumer; ... C90 compilers, the behavior is exactly as if it were not a reserved ... comparisons will have the same value in both languages only in the ...
    (comp.lang.c)
  • Re: C newbie - pass a LDAP handle out to calling routine
    ... int cfunc; ... When calling C routines from other languages like COBOL or PL/1, ... For IBM-MAIN subscribe / signoff / archive access instructions, ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ...
    (bit.listserv.ibm-main)