Issue 53660

Summary: "Create Query in Design View" ui/l10n -> program logic dependency
Product: Base Reporter: ivo.hinkelmann
Component: codeAssignee: Frank Schönheit <frank.schoenheit>
Status: CLOSED FIXED QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P2 CC: issues
Version: OOo 1.0.0Keywords: oooqa
Target Milestone: OOo 2.0.1   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description ivo.hinkelmann 2005-08-23 12:31:36 UTC 
For the "Create Query in Design View" we have two UI strings:

dbaccess/source/ui/querydesign/query.src:

String STR_QUERY_FUNCTIONS
{
    /* Gleiche Textreihenfolge fuer die Funtkionen wie in common.src */
    Text [ de ] = "(keine
Funktion);Durchschnitt;Anzahl;Maximum;Minimum;Summe;Gruppierung";
    Text [ en-US ] = "(no function);Average;Count;Maximum;Minimum;Sum;Group";
};

svx/source/form/fmstring.src:
String RID_STR_SVT_SQL_INTERNATIONAL
{
    Text [ de ] =
"WIE;NICHT;LEER;WAHR;FALSCH;IST;ZWISCHEN;ODER;UND;Durchschnitt;Anzahl;Maximum;Minimum;Summe"
;
    Text [ en-US ] =
"LIKE;NOT;EMPTY;TRUE;FALSE;IS;BETWEEN;OR;AND;Average;Count;Maximum;Minimum;Sum" ;
};

There are some (!) words, where the translation must 100% match in the other
string, or program logic is broken ... 

Like svx "Count" <> dbaccess "Count" , if the word is misspelled or one strings
is not translated, the count funktion do not work. This is a poor design that
add a unnecessary dependency UI/l10n to functionallity. The "view" should be
independent from program logic!

For further details see #i50727#
Comment 1 ocke.janssen 2005-08-26 08:04:19 UTC 
Fixed in cws dba201c
Comment 2 ivo.hinkelmann 2005-09-23 16:22:10 UTC 
Does this fix obsoletes issue i50727 ?
Comment 3 Frank Schönheit 2005-09-27 08:47:07 UTC 
Probably yes. Ocke?
Comment 4 ocke.janssen 2005-10-12 07:47:06 UTC 
Please verify. Thanks.

re-open issue and reassign to fs@openoffice.org
Comment 5 ocke.janssen 2005-10-12 08:40:08 UTC 
.
Comment 6 ocke.janssen 2005-10-12 08:41:48 UTC 
.
Comment 7 Frank Schönheit 2005-10-13 14:20:44 UTC 
looks good
Comment 8 thorsten.ziehm 2005-10-26 15:39:56 UTC 
This initial issue is integrated in m136, this mean it is integrated in
OOo2.0.1. I change the target to the correct one => OOo2.0.1.
Comment 9 ace_dent 2008-05-16 03:34:05 UTC 
This Issue is 'Verified' and not updated in 1yr+, so Closing.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~