To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=56282
                  Issue #:|56282
                  Summary:|it translation: cannot create GROUP BY - COUNT query
                Component:|Database access
                  Version:|OOO 2.0 Beta2
                 Platform:|PC
                      URL:|
               OS/Version:|Windows XP
                   Status:|UNCONFIRMED
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|DEFECT
                 Priority:|P3
             Subcomponent:|none
              Assigned to:|dbaneedsconfirm
              Reported by:|dtinazzi





------- Additional comments from [EMAIL PROTECTED] Wed Oct 19 08:11:14 -0700 
2005 -------
OOO 2.0 rc3 Italian translation - base file connected to MsAccess table 
(TABLE1).

I use the query builder to create a query like:

SELECT FIELD1, COUNT(FIELD2) FROM TABLE1 GROUP BY FIELD1

I put the table on the query panel, select the fields (FIELD1 and FIELD2), then
on the function line (in Italian the label is "Funzione") select "Gruppo" for
FIELD1 and "Quantità" for FIELD2. I run the query, the error message is:

Syntax error in SQL expression

parse error, expecting 'BETWEEN' or 'IN' or 'SQL_TOKEN_LIKE'

In "Extra":

Stato SQL: HY000
Codice di errore: 1000

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to